Search Discussions

802 discussions - 2,784 posts

  • Currently, Great-West Life has a full-time permanent position available in = the Financial Services Systems Division working on the Technical Infrastructure= team (comprised of System Administrators, ...
    Donita HilfingerDonita Hilfinger
    May 15, 2000 at 11:49 pm
    May 26, 2000 at 12:23 pm
  • I'd like to post a question for everyone on the list. How many of you have ever dropped a table, or done something like that in the wrong database(thinking you were connected to say the test DB), and ...
    Steve BoydSteve Boyd
    May 25, 2000 at 2:23 pm
    May 31, 2000 at 3:44 pm
  • Depends on what you're doing ....
    Andreas JungAndreas Jung
    May 22, 2000 at 7:06 am
    May 26, 2000 at 2:37 am
  • Is there somebody who knows how to change the MAXDATAFILES parameter value of a running database ? If so, I'm really very grateful to anyone who can explain me. Thank you friends !!!
    ALEMU AbiyALEMU Abiy
    May 30, 2000 at 2:45 pm
    May 31, 2000 at 4:22 pm
  • CASE - Benchmarking Application on a Specific Machine E 6.5 K SunOS 5.6 AIM - To pass 50,000 OLTP Transactions in 1 Hour using 2500 Oracle sessions (with respective Unix users) HARDWARE setup - Total ...
    May 16, 2000 at 5:44 am
    May 30, 2000 at 8:06 am
  • Hi List, One of the developers deleted more than 120,000 rows on a small database. In the middle of the session, he killed the process.(because hang) I did shutdown abort and startup again (waited a ...
    Joan HsiehJoan Hsieh
    May 18, 2000 at 8:13 pm
    May 26, 2000 at 9:48 pm
  • set ORACLE-L = DIGEST Trisha Hilger Database Developer Deposit Software Inc. thilger_at_depositsoft.com (360) 297-4742 x209
    Hilger, TrishaHilger, Trisha
    May 1, 2000 at 7:46 pm
    May 31, 2000 at 7:31 pm
  • Environment: AIX 4.2.1 Oracle 8.1.5 I migrated a test database from to 8.1.5. Anything obvious why the 8.1.5 database would be much slower than the 7.3.4 database ? Is there an init parameter ...
    May 17, 2000 at 2:44 am
    May 22, 2000 at 3:39 pm
  • Hi All, I have run utlestat & utlbstat plus some other scripts and have a lot of wait events Event Name Count Total Time Avg Time -------------------------------- ------------- ------------- ...
    Jack van ZanenJack van Zanen
    May 15, 2000 at 3:14 pm
    May 22, 2000 at 1:11 am
  • Ok, forgive me if I offend anyone....but the head honchos came and asked what the ramifications would be if we were to make every, yes EVERY varchar2 column in new database the length of 255. The ...
    Christine TurnerChristine Turner
    May 9, 2000 at 1:19 pm
    May 12, 2000 at 9:32 pm
  • This is by far the funniest thing I have ever done. I began running the create database scripts (ON A TEST MACHINE) when the $ORACLE_SID was set to a currently running database. It's now completely ...
    May 24, 2000 at 9:29 pm
    May 27, 2000 at 1:49 pm
  • Sorry. I couldn't let this one pass. I am not a headhunter. I am a DBA working for GWL and we do have a position open for an Oracle DBA (and yes, headhunters can be a pain, but they can also be ...
    Donita HilfingerDonita Hilfinger
    May 24, 2000 at 2:48 pm
    May 26, 2000 at 8:59 pm
  • Hi Guru's, Will any one tell, if there is any specific advantage if we don't have primary & foreign key constraints at database level. In one of our major applications I have seen, they do not have ...
    Rufus ChinnamRufus Chinnam
    May 23, 2000 at 4:31 am
    May 26, 2000 at 2:46 am
  • Does anyone know of a company that offers an Oracle DBA poster based on 8.1.5 / 8.1.6? TIA, Ken Kenneth C. Janusz, CPIM FINGERHUT DTC Senior Technical Analyst 6150 Trenton Lane North, DC4N Plymouth, ...
    Janusz, KennethJanusz, Kenneth
    May 29, 2000 at 1:42 pm
    May 31, 2000 at 12:12 pm
  • Hi, One of our trainee DBAs has managed to run catproc as system! Fortunately it is not a mission critical instance, though a production one. Surprisingly it is still running! Is there any easy way ...
    S. Anthony SequeiraS. Anthony Sequeira
    May 24, 2000 at 8:34 pm
    May 30, 2000 at 12:55 am
  • On querying the v$session_event, I could see one process taking a very large wait time. The process takes about 4 Hrs to complete on *this* instance (A), whereas it takes a few minutes on another ...
    Deepak SharmaDeepak Sharma
    May 3, 2000 at 4:57 pm
    May 5, 2000 at 5:30 pm
  • Here's an interesting thought - since Oracle very rarely wants the core dump files, and since they can consume a lot of space unless you routinely clean them up, is there any disadvantage to setting ...
    Dale youngDale young
    May 24, 2000 at 7:15 pm
    May 29, 2000 at 7:50 am
  • 14


    Hi guru=B4s=20 i want to know if is possible to do a substr or a instr in plsql with a = LONG field? thanks for all,
    Solis Llera, EduardoSolis Llera, Eduardo
    May 10, 2000 at 10:33 am
    May 15, 2000 at 12:44 pm
  • Hello - Does anyone have a script that checks if a series of databases are up and available that they would be willing to share? I set out to write a ksh script to do this and found that I would have ...
    May 10, 2000 at 3:13 pm
    May 12, 2000 at 7:45 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB9BD.5D9C4786 Content-Type ...
    Webber Valerie HWebber Valerie H
    May 9, 2000 at 1:49 pm
    May 11, 2000 at 11:57 pm
  • Hello everyone - Anyone run into a problem with dynamically compressing an export with a pipe? I am told that importing a file after this type of export/compression is not 100%. Sometimes imp thinks ...
    May 23, 2000 at 1:52 pm
    May 24, 2000 at 1:36 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0030_01BFB6DF.3F342F10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I need your ...
    Surjit SharmaSurjit Sharma
    May 5, 2000 at 12:14 pm
    May 8, 2000 at 3:16 pm
  • Hi folks- I'm trying to simplify the process of creating a user account for a COTS = package where I can't touch the code. There's some user configuration = within the application, and of course ...
    Jim ConboyJim Conboy
    May 24, 2000 at 1:44 pm
    May 25, 2000 at 2:08 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_23B1_01BFC0A8.21035B10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there no way to ...
    Eric LansuEric Lansu
    May 18, 2000 at 7:04 am
    May 24, 2000 at 9:04 am
  • Oracle ver 8 Can Theoretically Support a MAX 512 Peta bytes Database Size Wha is ONE Peta Byte Equal to ?
    May 18, 2000 at 9:21 am
    May 18, 2000 at 11:23 pm
  • I am presently reading a book called: Guide to Oracle8i Features by Steven Feuerstein O'Reilly Hope this helps Sarto Beaudoin Hi, DBAs! Would You please recommend a paper on Oracle8i new features ....
    Sarto BeaudoinSarto Beaudoin
    May 8, 2000 at 1:32 pm
    May 13, 2000 at 6:50 am
  • I am at a site right now where I don't have any documentation. How do you rebuild an index? Thanks.
    Connie MillikenConnie Milliken
    May 2, 2000 at 3:19 pm
    May 3, 2000 at 7:01 pm
  • Hello all when i do a connect internal/password_at_connect string, i get the message INSUFFICIENT PRIVILIGES. i does work with sys/password_at_connect string. anyone with a suggestion ? g. kor
    Kor, GeoKor, Geo
    May 30, 2000 at 7:18 am
    May 31, 2000 at 8:06 pm
  • 11


    <!doctype html public "-//w3c//dtd html 4.0 transitional//en" test
    Mohammad ShujaMohammad Shuja
    May 3, 2000 at 4:59 pm
    May 27, 2000 at 12:19 am
  • Hi all, I have a COMMA DELIMITED text file, that has parent records and child records in the same text file. Now how do I differentiate and relate a parent record to a child record and insert the ...
    Radhika Rao PutumbakaRadhika Rao Putumbaka
    May 4, 2000 at 7:06 pm
    May 26, 2000 at 12:57 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB9CB.E71ECE9E Content-Type ...
    Bruce PageBruce Page
    May 9, 2000 at 3:32 pm
    May 12, 2000 at 12:11 am
  • Once ORACLE has allocated the space for a datafile df thinks it is used. RBG ----- Original Message ----- From: To: Multiple recipients of list ORACLE-L Sent: Sunday, April 30, 2000 3:14 PM Subject ...
    Ruth GramoliniRuth Gramolini
    May 1, 2000 at 1:33 pm
    May 2, 2000 at 3:38 pm
  • Look like you disabled automatic archiving of log files but left the database in archive log mode. To disable archiving you need to do the following (btw you don't need to touch the log_archive_start ...
    May 1, 2000 at 1:49 pm
    May 2, 2000 at 12:48 pm
  • hi all, hope you're ok I have this "silly" question. Is there an easy way to retrieve the last 10 records that have been entered in a given table? TIA --Yohans Yohans Mendoza System Analyst ...
    Yohans MendozaYohans Mendoza
    May 30, 2000 at 11:12 pm
    May 31, 2000 at 4:06 pm
  • Hi I have just cloned our production DB to a test machine (ie copy all datafiles, init files, netwrok files etc) after doing recovery on the DB I can connect through server manager and see all the ...
    Sajid IqbalSajid Iqbal
    May 30, 2000 at 12:10 pm
    May 31, 2000 at 11:57 am
  • Hi group how do i despeciali. % char in like operator?. prod_name =-------- prod 100% i want to select all product which contains % as a pattern. TIA H.Karthikeyan Tata Infotech Ltd., System ...
    May 25, 2000 at 8:27 am
    May 25, 2000 at 1:40 pm
  • Running Oracle 8.0.5 on AIX... In doing rebuilds of indexes, I am blowing up with the following error: ORA-01652: unable to extend temp segment by 2048 in tablespace PMADTLX In retrying, the rebuild, ...
    Wayne S BellefeuilleWayne S Bellefeuille
    May 15, 2000 at 4:14 pm
    May 15, 2000 at 8:49 pm
  • Hi all, I just created a new db with the create database command. Everything seemed to be working fine except that the dba views were missing so I ran catalog.sql. Now sqlplus works fine except that ...
    Michael JohnsonMichael Johnson
    May 2, 2000 at 5:01 pm
    May 5, 2000 at 8:49 am
  • Hi all - Being new to Oracle, I'm not sure if this is a common occurrence or if it indicates anything in particular. We have an application (Lawson) using Oracle 8.1.5 (on NT, more's the pity). I ...
    Warthling, ChristyWarthling, Christy
    May 3, 2000 at 1:03 pm
    May 4, 2000 at 2:09 am
  • Howdy all, I just started work at a leetle place which does data warehousing, and my current project involves a 40GB database with some 19.5million rows. So, I'm not surprised when simple operations ...
    R BresnerR Bresner
    May 1, 2000 at 1:35 pm
    May 3, 2000 at 3:29 pm
  • Automatic tree-balancing is a basic feature of the btree algorithm. I wrote a btree function once just to get a feel for what it does, and I can tell you that it makes absolutely no difference ...
    I.S. ManagerI.S. Manager
    May 1, 2000 at 3:23 pm
    May 2, 2000 at 4:40 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_00D7_01BFB36A.DE37B000 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When would you want ...
    Walter K.Walter K.
    May 1, 2000 at 5:43 pm
    May 1, 2000 at 10:27 pm
  • Hi All: In a couple of weeks I will be joining another company as an Oracle DBA. This will be the first time for me as a DBA. Although I a have a good idea of what the job entails, I could use some ...
    Janusz, KennethJanusz, Kenneth
    May 30, 2000 at 7:55 pm
    May 31, 2000 at 1:35 pm
  • Did you overlay the control files with the backed up control files? ............................................................................ ................................. Rich Gesler - < < ...
    Gesler, RichardGesler, Richard
    May 19, 2000 at 1:03 pm
    May 31, 2000 at 9:13 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC0F0.383299AC Content-Type ...
    Bruce PageBruce Page
    May 18, 2000 at 5:40 pm
    May 24, 2000 at 3:03 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFBDCB.0B34DFA0 Content-Type ...
    Alex HillmanAlex Hillman
    May 14, 2000 at 5:37 pm
    May 17, 2000 at 5:13 pm
  • All, currently we have a Access database with 25 to 30 tables. Client is planning to no longer use Access and to migrate the whole database to Oracle. What is the best way to move from Access to ...
    Radhika Rao PutumbakaRadhika Rao Putumbaka
    May 16, 2000 at 2:00 am
    May 16, 2000 at 8:42 pm
  • We have a BusinesObjects universe on an NT box and linked to Oracle database. We ran into a problem that stumped us. The BusinessObjects' Document Agent Server is not able to process any documents ...
    May 11, 2000 at 8:53 pm
    May 12, 2000 at 5:11 pm
  • Hi listers, What script do I have to run to be able to execute=20 sys.dbms_system.set_sql_trace_in_session(41,2335,TRUE) (as an example) I used to run this very often, and now I can't generate a ...
    Veronica LevinVeronica Levin
    May 4, 2000 at 3:52 pm
    May 8, 2000 at 2:26 pm
  • Hello, I'am getting a very slow response on the query that calls a function after getting a variable. The query is used in pert script. The function after getting the variable do a select statement & ...
    salu Ullahsalu Ullah
    May 4, 2000 at 10:58 pm
    May 7, 2000 at 12:46 am
Group Navigation
period‹ prev | May 2000 | next ›
Group Overview
grouporacle-l @

509 users for May 2000

Jared Still: 68 posts Winnie_Liu_at_infonet.com: 63 posts Ruth Gramolini: 59 posts Dgoulet_at_vicr.com: 52 posts Rachel Carmichael: 48 posts CHUCK_HAMILTON_at_qvc.com: 42 posts Lisa_Koivu_at_gelco.com: 40 posts George.Brennan_at_warnermusic.com: 39 posts Deshpande, Kirti: 35 posts A. Bardeen: 30 posts Atish Prasad Das: 30 posts Jack van Zanen: 30 posts Andreas Jung: 29 posts Rajagopal Venkataramany: 29 posts Joseph S. Testa: 28 posts Thapliyal, Deepak: 28 posts Alex Hillman: 25 posts Guy ruth hammond: 25 posts Jamadagni, Rajendra: 24 posts VIVEK_SHARMA: 24 posts
show more