FAQ

Search Discussions

817 discussions - 2,548 posts

  • Hi, Our ITS department is re-structuring and there is some disagreement over where the DBA role fits into the new structure. Some feel the DBA is more closely aligned with the application development ...
    Ben PoelsBen Poels
    Nov 24, 2000 at 2:30 pm
    Nov 28, 2000 at 5:08 pm
  • SET ORACLE-L MAIL The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Nov 2, 2000 at 9:22 am
    Nov 29, 2000 at 4:58 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_01C04DC1.EAE13FD2 Content-Type ...
    Burton, Laura L.Burton, Laura L.
    Nov 13, 2000 at 10:34 pm
    Nov 16, 2000 at 2:50 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_01C04F25.FD6256F0 Content-Type ...
    Satar NaghshinehSatar Naghshineh
    Nov 15, 2000 at 5:03 pm
    Nov 22, 2000 at 10:48 am
  • Hi All, Hit me with shameless plugs here. Anybody know of any tool/utility etc that will compare schema A on instance A with Schema A on instance B. Down to the nitty gritty details. I Like all ...
    Nlzanen1_at_ey.nlNlzanen1_at_ey.nl
    Nov 16, 2000 at 3:31 pm
    Nov 21, 2000 at 10:39 pm
  • I have a 45GB Oracle 8.0.5 database on HPUX. I want to be able to do nightly exports so that if any of the tables gets "accidentally" truncated or whatever, we can restore just the table and not have ...
    Cemail_at_sprintmail.comCemail_at_sprintmail.com
    Nov 17, 2000 at 6:25 pm
    Nov 20, 2000 at 10:06 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0263_01C044B1.1EFB74F0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi listers! I want ...
    Sonja �ehovi�Sonja �ehovi�
    Nov 2, 2000 at 8:41 am
    Nov 3, 2000 at 7:52 pm
  • i want my 'order by' transaction to be quick...very quick ... what oracle parameter should i increase or decrease ??? Thanks a lot . "bunyamin karadeniz" on 07/11/2000 02:55:22 AM Please respond to ...
    Marcos.Vera_at_msconsultores.com.peMarcos.Vera_at_msconsultores.com.pe
    Nov 7, 2000 at 3:26 pm
    Nov 8, 2000 at 8:20 pm
  • I looked up the world "adult" in my movie/tv rating dictionary. Why should he be made to have a sleezy, designed to shock beverage? ----- Original Message ----- From: Eric D. Pierce To: Multiple ...
    Tom PallTom Pall
    Nov 1, 2000 at 12:08 am
    Nov 16, 2000 at 4:01 am
  • All, Oracle 8.0.5 Is there a method of getting rid of the locks or indded the session once it has been marked as killed. We need to get rid of this session without bouncing the DB. Any ideas ?? ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Nov 9, 2000 at 12:53 pm
    Nov 14, 2000 at 1:16 am
  • Hi list, Does anyone have a document with a good map of the dba_tables, and v$views? I have heard about the posters on the list, but these are for U.S. citizens right? Us poor lowly Brits have to ...
    Mark LeithMark Leith
    Nov 3, 2000 at 9:50 am
    Nov 10, 2000 at 10:23 pm
  • Hi everyone I have launched the following query in SQL*PLUS SQL L 1* SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO = NULL; SQL / 1 row selected. SQL SELECT COUNT(*) FROM WERK_ORDER WHERE ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Nov 9, 2000 at 2:12 pm
    Nov 10, 2000 at 3:10 pm
  • Hi, I am having a problem updating a table. Using 8.1.6.1 on NT. I can update other tables owned by user 'BOB'. All tables were created via IMPORT. Table X 'should' be the same as the rest. But no ...
    Bond, MikeBond, Mike
    Nov 29, 2000 at 4:30 pm
    Nov 29, 2000 at 10: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_01C05943.A27C2620 Content-Type ...
    Koivu, LisaKoivu, Lisa
    Nov 28, 2000 at 2:00 pm
    Nov 29, 2000 at 10:34 am
  • Hi DBAs I have hot backup script running on unix box.I have not testesed yet.What will be the best way to test recovery of database.I have 8 instances running on Unix box. Please suggest. Thanks Mala ...
    Mala singhMala singh
    Nov 8, 2000 at 9:48 pm
    Nov 14, 2000 at 10:15 pm
  • Hello List! I'm having trouble comprehending the idea of an Index Organized table. The Oracle 8i DBA Bible has this paragraph in it: An index-organized table is one in which the entire table is ...
    Hannah.M.Doran_at_sb.comHannah.M.Doran_at_sb.com
    Nov 10, 2000 at 12:05 pm
    Nov 10, 2000 at 7:12 pm
  • can I get some feedback from dba's out there have have a top 10 or so list of things they regularly look for when doing performance tuning?...what things do you look at or for to determine the ...
    Roy FergusonRoy Ferguson
    Nov 7, 2000 at 9:52 pm
    Nov 8, 2000 at 6:30 pm
  • Really! I would have thought that an extremely intelligent person coming from a totalitarian socialist society that made the huge mistake of trying to turn science into an atheistic central-state ...
    Eric D. PierceEric D. Pierce
    Nov 1, 2000 at 1:09 am
    Nov 1, 2000 at 11:40 pm
  • hi,all i am reading Oracle Discoverer handbook and see a word "ad hoc query". but i don't know the exact meaning of this, nor can i find the meaning in dictionary. i am a non-native english speaker, ...
    ZhuchaoZhuchao
    Nov 15, 2000 at 7:44 am
    Nov 27, 2000 at 7:19 pm
  • Why cant I change the minextents? SVRMGR alter rollback segment r05 2 storage (minextents 10); alter rollback segment r05 * ORA-01570: MINEXTENTS must be no larger than the 4 extents currently ...
    Larry TaylorLarry Taylor
    Nov 9, 2000 at 5:21 pm
    Nov 13, 2000 at 1:12 pm
  • Hi, In a web related application executing a query it takes lots of time.Performance is very poor it seems. So please suggest me to do the performance good what are the points to be done or rectified ...
    Dash, Saroj (CAP,CEF)Dash, Saroj (CAP,CEF)
    Nov 1, 2000 at 1:57 am
    Nov 3, 2000 at 5:03 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0123_01C04D50.7B7A29E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Do anyone ...
    Anjali RAnjali R
    Nov 13, 2000 at 6:02 am
    Nov 20, 2000 at 9:12 am
  • Here's a new recipe I discovered today for putting egg on my face: Run low on disk on the server Hurriedly delete "unused" database files in order to free up space because you are behind on a ...
    Jonathan GennickJonathan Gennick
    Nov 15, 2000 at 12:57 am
    Nov 17, 2000 at 6:41 pm
  • Use SQL*Plus to format the output, and then spool the results to a flat file. if the linesize is too wide, you can also write a PL/SQL procedure to read the data, format it and write it to a spooled ...
    Rachel CarmichaelRachel Carmichael
    Nov 6, 2000 at 3:27 pm
    Nov 13, 2000 at 4:39 am
  • What is the difference between building a table and including the primary key versus building the table and then having creating a unique index on the same keys? When you create a table with a ...
    Cemail_at_sprintmail.comCemail_at_sprintmail.com
    Nov 30, 2000 at 5:57 am
    Nov 30, 2000 at 8:46 pm
  • Hi all, So I was just handed a small Sun box to play with. I thought ... hmmm I could use a new RMAN catalog. I also thought hmmm I would like to try playing with 8.1.7 ... so these together caused ...
    Adam TurnerAdam Turner
    Nov 28, 2000 at 9:09 pm
    Nov 29, 2000 at 7:49 pm
  • Hi, I have create a user X whose has admin permission. other than system and sys. I have given the permission to X is like this. grant delete any table,insert any table to X. Now i created another ...
    Dash, Saroj (CAP,CEF)Dash, Saroj (CAP,CEF)
    Nov 16, 2000 at 4:41 am
    Nov 20, 2000 at 3:12 pm
  • Hi All, For the SQL experts out there. I have the tables PAGE_VIEWS VIEW_ID NUMBER(10,0) HTML_PAGE_ID NUMBER(10,0) VIEW_DATE DATE HTML_PAGE PAGE_ID NUMBER(10,0) URL VARCHAR2(255) ... ...
    Dave MorganDave Morgan
    Nov 15, 2000 at 4:24 pm
    Nov 17, 2000 at 5:15 pm
  • Hi All, I have enabled disk_async_io to TRUE at the database level. Is there a configuration parameter on Solaris that you need to set to enable Async I/O at O/S level? Thanks, Jay
    Jay MehtaJay Mehta
    Nov 9, 2000 at 9:47 pm
    Nov 15, 2000 at 6:25 pm
  • Hi everyone. I've been working a critical 8.1.7 bug most of the day that I thought you would give you a heads up on: The short of the story is that MTS is basically broken in Oracle 8.1.7.0 on ...
    Roby ShermanRoby Sherman
    Nov 9, 2000 at 12:31 am
    Nov 13, 2000 at 6:28 pm
  • Hello Lists, Can anybody help me in locating a power point / any other resource for training a team. It can be from basic to expert level. I remember to have seen at some site such as orafaq.com. I ...
    Murugesan BalakrishnanMurugesan Balakrishnan
    Nov 10, 2000 at 12:52 am
    Nov 10, 2000 at 4:38 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_01C05880.552D4624 Content-Type ...
    Koivu, LisaKoivu, Lisa
    Nov 27, 2000 at 2:42 pm
    Nov 27, 2000 at 7:04 pm
  • Hi all I need to schedule a procedure using dbms_job. I created it using the following script. declare jobno number; begin dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', sysdate,'sysdate+1') ...
    Raj GopalanRaj Gopalan
    Nov 21, 2000 at 5:43 pm
    Nov 25, 2000 at 2:22 pm
  • Hi, We have 3 oracle instances(8.1.6) running on unix(hp-ux v11) box. Following 'ipcs -m' command shows the shared memory segments for 3 instances. How do I know which shared segment belongs to which ...
    Prasada.Gunda1_at_hartfordlife.comPrasada.Gunda1_at_hartfordlife.com
    Nov 22, 2000 at 6:25 pm
    Nov 23, 2000 at 10:57 am
  • This is a multi-part message in MIME format. --------------0F5CFFD3629D20C58C32FFAE Content-Type: multipart/alternative; boundary="------------40D6FE152026A96AEFA46B02" ...
    Arul kumarArul kumar
    Nov 21, 2000 at 4:50 am
    Nov 22, 2000 at 12:38 pm
  • Hi, we also got a Sybase database in our company and I never worked with Sybase before. Can anyone recommend some documentation for someone who knows Oracle? Is there a Sybase mailing list as well? ...
    Sackwitz, AntjeSackwitz, Antje
    Nov 16, 2000 at 10:50 am
    Nov 16, 2000 at 10:06 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_01C04B15.F39F1E80 Content-Type ...
    Uma Sankara_SivadanamUma Sankara_Sivadanam
    Nov 10, 2000 at 12:58 pm
    Nov 13, 2000 at 4:54 pm
  • hello all, can somebody plz help me to explain about oracle clustering ? is oracle clustering equal to Oracle Parallel Server ? is it considered as software clustering ? wha'ts the different, ...
    HermanHerman
    Nov 27, 2000 at 7:18 am
    Nov 30, 2000 at 7:16 pm
  • Dear DBA gurus, I have some data in Excel sheet which is in xls format which I have to load into Oracle tables. How do I do it? Any help in this regard will be highly appreciated. TIA and regards, ...
    RanganathK_at_lgcommerznow.comRanganathK_at_lgcommerznow.com
    Nov 30, 2000 at 8:37 am
    Nov 30, 2000 at 12:40 pm
  • Is it possible to define a foreign key on a table which references a table in a different schema? I tried but got 'insufficient privs' error.
    Glenn TravisGlenn Travis
    Nov 21, 2000 at 9:18 pm
    Nov 27, 2000 at 8:04 pm
  • Hi dear ALL What is it application server as applied to Oracle? And where can I get it? ura_at_ymz.yaroslavl.ru Ura!
    Ura!Ura!
    Nov 15, 2000 at 5:00 am
    Nov 16, 2000 at 9:16 pm
  • Hi All, It seems that the issue of asynchronous I/O on Solaris is still alive and kicking. Here is an attempt to pull the threads together. Oracle 7 had an 'async_write' parameter that used to ...
    Steve AdamsSteve Adams
    Nov 14, 2000 at 7:00 am
    Nov 15, 2000 at 11:02 pm
  • Subject: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size on size of SGA TYT (take your time to respond - ie. just FYI, not production issue). I've been studying the Oracle8i DBA bible and ...
    Hannah.M.Doran_at_sb.comHannah.M.Doran_at_sb.com
    Nov 14, 2000 at 12:55 pm
    Nov 15, 2000 at 5:43 pm
  • Lists, When i run select * from v$pwfile_users on my solaris machin returns no rows(oracle 8.1.5 on solaris), I have tried to connect as sysdba but couldn't. How can i grant sysdba to sys, any idea ...
    Hamid AlaviHamid Alavi
    Nov 6, 2000 at 2:47 am
    Nov 9, 2000 at 3:14 pm
  • Hello Everyone, I am newbie to unix. I am trying to write a script where all the files starting with BUSH_ will change to GORE_ or vice-versa (Depending upon the election results). I am not sure what ...
    Sonia pajerowskiSonia pajerowski
    Nov 7, 2000 at 7:06 pm
    Nov 8, 2000 at 4:56 pm
  • Our client has a table which will have over 200 updates and 100 inserts every second. Should I leave the default setting for inittrans or should I increase the value of this parameter. Can someone ...
    Sonia pajerowskiSonia pajerowski
    Nov 6, 2000 at 2:46 pm
    Nov 7, 2000 at 2:04 pm
  • RDBMS: 8.0.5 We are using RMAN to backup a critical production 600G database. We have a successful level-0 backup and do level-1 backups 3 times a week. To the best of my knowledge we have never done ...
    Blair_at_pjm.comBlair_at_pjm.com
    Nov 1, 2000 at 4:07 pm
    Nov 3, 2000 at 2:14 am
  • List, A fellow DBA has asked if it is completely safe to change the pctfree values etc on a live system. I thought there shouldn't be any isues as no data is actually being changed only the default ...
    Steve.Parker_at_lis.co.ukSteve.Parker_at_lis.co.uk
    Nov 1, 2000 at 5:41 pm
    Nov 1, 2000 at 11:37 pm
  • We are currently on an AIX RS6000 box using Oracle 8.1.6. I created a locally managed tablespace (to be used for indexes). I then issued an alter index rebuild command specifying the new tablespace ...
    Terry BallTerry Ball
    Nov 2, 2000 at 2:59 pm
    Nov 30, 2000 at 7:06 pm
  • Hello list, I have a query select d.discount_type from discount d where (d.company_code = 'XX' or d.company_code is null) and (d.operator_code = 'YY' or d.operator_code is null) Apparently, oracle is ...
    Raj GopalanRaj Gopalan
    Nov 22, 2000 at 5:31 pm
    Nov 27, 2000 at 3:16 pm
Group Navigation
period‹ prev | Nov 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions817
posts2,548
users465
websiteoracle.com

465 users for November 2000

Jared Still: 57 posts Tom Pall: 54 posts Eric D. Pierce: 53 posts Hannah.M.Doran_at_sb.com: 49 posts Michael Ray: 34 posts Koivu, Lisa: 32 posts Mohan, Ross: 32 posts Ron Rogers: 30 posts Alex Hillman: 29 posts Javier Morales: 28 posts Ruth Gramolini: 28 posts Shevtsov, Eduard: 28 posts Dgoulet_at_vicr.com: 26 posts Rachel Carmichael: 26 posts Diana Duncan: 24 posts lerobe - Lee Robertson: 23 posts Dash, Saroj (CAP,CEF): 22 posts Steve Adams: 22 posts Gogala, Mladen: 21 posts Yong huang: 21 posts
show more
Archives