Search Discussions

444 discussions - 2,047 posts

  • how can a dba see the password of a user.The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET ...
    Faisal ahmadFaisal ahmad
    Dec 17, 2002 at 4:09 am
    Dec 21, 2002 at 11:38 pm
  • Tis the season to give. At least thats what i've been told. Anyway, I've put together a little page of my favorite sql scripts. (I've actually written only about 1/2 of them. The rest are stolen from ...
    Toepke, Kevin MToepke, Kevin M
    Dec 19, 2002 at 7:54 pm
    Dec 24, 2002 at 4:48 am
  • I was told by the department manager that they were neither using a direct load nor the Append hint. But the developer is back from vacation today so I'll get a more definite answer from him. Thanks, ...
    Miller, JayMiller, Jay
    Dec 2, 2002 at 7:23 pm
    Dec 6, 2002 at 9:18 pm
  • Anyone have any useful scripts for doing this? TIA, Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Huntley INET: rhuntley_at_mindleaders.com Fat City Network ...
    Richard HuntleyRichard Huntley
    Dec 26, 2002 at 8:24 pm
    Dec 31, 2002 at 3:54 pm
  • Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has ...
    Koivu, LisaKoivu, Lisa
    Dec 31, 2002 at 1:43 pm
    Dec 31, 2002 at 10:04 pm
  • Listers, 64 Bit Solaris Does row migration utilize DB File Sequential Reads on the table? Off the top of my head I would expect so, but I've never tested something like that before. Trying to ...
    Larry ElkinsLarry Elkins
    Dec 27, 2002 at 12:08 am
    Dec 30, 2002 at 1:43 am
  • How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author ...
    Nguyen, David MNguyen, David M
    Dec 9, 2002 at 10:23 am
    Dec 13, 2002 at 4:59 pm
  • I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I ...
    Burton, Laura L.Burton, Laura L.
    Dec 5, 2002 at 7:24 pm
    Dec 9, 2002 at 1:03 pm
  • Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've ...
    Kieran MurrayKieran Murray
    Dec 4, 2002 at 5:24 pm
    Dec 5, 2002 at 5:14 pm
  • I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql ...
    Bob MetelskyBob Metelsky
    Dec 18, 2002 at 3:15 pm
    Dec 19, 2002 at 3:54 pm
  • Hi How to clean all old STATSPACK data? Thx -Seema STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ ...
    Seema SinghSeema Singh
    Dec 9, 2002 at 4:14 pm
    Dec 13, 2002 at 8:09 pm
  • Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose ...
    Post, EthanPost, Ethan
    Dec 2, 2002 at 10:33 pm
    Dec 4, 2002 at 5:44 pm
  • Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar ...
    Ashraf SalaymehAshraf Salaymeh
    Dec 18, 2002 at 4:58 am
    Dec 20, 2002 at 7:28 am
  • I thought I had these files stopped .... but apparently not. Is there somone out there who can tell me how to stop the Audit files from appearing in the audit_file_dest ??? I thought if I set the ...
    Kevin LangeKevin Lange
    Dec 26, 2002 at 10:59 pm
    Dec 30, 2002 at 3:53 pm
  • Hi, list friends: I am reading oracle 9.2 performance planning manual, and see it says: Today's date. SELECT SYSDATE FROM DUAL can account for over 60% of the workload on a database. {page 33 of that ...
    Dec 26, 2002 at 1:18 pm
    Dec 27, 2002 at 12:22 pm
  • You can try using the wakeup parameter of oradebug. You need to get the process ID of the pmon process, select pid from v$process p,v$bgprocess b where b.paddr = p.addr and name = 'PMON' then ...
    Kurth, Michael J.Kurth, Michael J.
    Dec 24, 2002 at 2:33 pm
    Dec 27, 2002 at 4:25 pm
  • We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments: SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 ----- ----------------- ---------- -- -------- -- ...
    Thomas JeffThomas Jeff
    Dec 20, 2002 at 2:44 pm
    Dec 23, 2002 at 6:13 pm
  • Hello All, I am currently working on capacity planning of the database, expecting the database size based on the business object,sales ( Historical data). I am not sure about the approach I am ...
    Reddy, MadhusudanaReddy, Madhusudana
    Dec 17, 2002 at 2:18 am
    Dec 18, 2002 at 6:38 pm
  • As part of the process of making sure that null/not null constraints are consistent across development/staging/production, I'm looking at the dba_cons_columns table. Now, as far as I know, ...
    Rachel CarmichaelRachel Carmichael
    Dec 30, 2002 at 8:23 pm
    Dec 31, 2002 at 3:14 pm
  • Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct;)) things in the archive. Anyway: Due to my lack ...
    Stefan JahnkeStefan Jahnke
    Dec 20, 2002 at 12:34 pm
    Dec 23, 2002 at 10:53 pm
  • 14


    Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- ...
    Farnsworth, DaveFarnsworth, Dave
    Dec 12, 2002 at 6:14 pm
    Dec 17, 2002 at 9:12 pm
  • RE: Oracle 9i installation - Basic Qs - HELP!Hi, How can I archive redo logs automatically to a different machine ?. Standby database is not an option because the target machine's OS is different ...
    Bala RegupathyBala Regupathy
    Dec 10, 2002 at 8:06 pm
    Dec 11, 2002 at 4:04 pm
  • which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shao, Chunning ...
    Shao, ChunningShao, Chunning
    Dec 18, 2002 at 9:33 pm
    Dec 19, 2002 at 7:45 pm
  • What is the Best Practice for DB_BLOCK_SIZE for Index Tablespaces Undergoing High Volume of Insert, Update, Selects ? Why ? Any Docs, Links for the Same ? NOTE - This is for a Hybrid Application ...
    Dec 17, 2002 at 4:28 pm
    Dec 23, 2002 at 4:49 pm
  • We are trying to test out monitoring software (on a test database at We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ...
    Ball, TerryBall, Terry
    Dec 19, 2002 at 8:51 pm
    Dec 20, 2002 at 6:46 pm
  • Folks, I know that when creating indexes a couple of settings such as SORT_AREA_SIZE can have a big impact on duration. What settings apply during online rebuilds? Are the rules the same? What tips ...
    Mark RichardMark Richard
    Dec 5, 2002 at 5:48 am
    Dec 13, 2002 at 11:58 pm
  • Hi, Oracle 8.1.6 NT 4.0 I have a rather complex query a developer gave to me to try to improve performance. There are 3 tables used. All relevant columns used are indexed. The tables have been ...
    Dec 6, 2002 at 12:53 pm
    Dec 9, 2002 at 12:24 pm
  • Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ...
    Donahue, AdamDonahue, Adam
    Dec 6, 2002 at 4:41 pm
    Dec 9, 2002 at 1:23 am
  • I don't manage the mail list software, Bruce Bergman does. Though these are a minor annoyance, I personally wouldn't bother writing code/rules to eliminate these. Just hit Jared "Naveen Nahata" Sent ...
    Dec 3, 2002 at 5:23 pm
    Dec 31, 2002 at 8:58 am
  • Whoa! Tim, thanks a lot for sharing this. Quite an insight. So SELECTs are not a concern. INSERTs are a "come and see DBA" thing (physical design issue). DELETEs are relatively infrequent and many ...
    Boris DaliBoris Dali
    Dec 4, 2002 at 3:53 pm
    Dec 6, 2002 at 3:54 pm
  • I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. We had some maintenance ...
    Stephen AndertStephen Andert
    Dec 2, 2002 at 9:33 pm
    Dec 5, 2002 at 8:06 pm
  • Hi Listers, I'm new on Oracle Database 9i after I migrated from Oracle 8i. I try to use backup facility from Oracle 9i and I already follow the instructions how to activate the automatic backup but ...
    Sony kristantoSony kristanto
    Dec 27, 2002 at 1:23 am
    Dec 29, 2002 at 3:58 pm
  • It is possible for ITL starvation to result in deadlocks, and changing INITRANS (and rebuilding the problem objects) would help - but no-one can give you an appropriate answer without seeing the ...
    Jonathan LewisJonathan Lewis
    Dec 20, 2002 at 8:43 am
    Dec 27, 2002 at 8:58 pm
  • RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs ...
    Dec 19, 2002 at 3:50 pm
    Dec 26, 2002 at 6:58 am
  • Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net ...
    Sony kristantoSony kristanto
    Dec 20, 2002 at 6:43 am
    Dec 21, 2002 at 3:13 am
  • http://education.oracle.com and search for D12856GC10 Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ...
    Jamadagni, RajendraJamadagni, Rajendra
    Dec 13, 2002 at 6:59 pm
    Dec 20, 2002 at 3:45 pm
  • Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data as follows: SHIP_ID SHIP_NAME ------------- ------------------- ABC 1ABCLMN XYZ 23XYZ1112 ABB 123LM I want ...
    Krishnaswamy, RanganathKrishnaswamy, Ranganath
    Dec 17, 2002 at 10:38 am
    Dec 18, 2002 at 6:38 am
  • Is there no way to produce a report from the RMAN views/tables that lists the date and duration of the backups for each database? I have pored through the RC views and can produce such a report at ...
    Walter KWalter K
    Dec 11, 2002 at 6:11 pm
    Dec 17, 2002 at 12:59 pm
  • Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback ...
    Markham, RichardMarkham, Richard
    Dec 16, 2002 at 4:18 pm
    Dec 17, 2002 at 9:18 am
  • ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running ...
    Chris StephensChris Stephens
    Dec 10, 2002 at 5:30 pm
    Dec 16, 2002 at 10:23 pm
  • Guys, i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be ...
    Oraora oraoraOraora oraora
    Dec 3, 2002 at 10:48 am
    Dec 4, 2002 at 8:23 am
  • In the 9i SQL Reference Guide Release 2 9.2, under "CREATE TABLESPACE", "segment_management_clause" Restrictions on the AUTO clause: · You can specify this clause only for permanent, locally managed ...
    Hemant K ChitaleHemant K Chitale
    Dec 15, 2002 at 2:38 am
    Dec 27, 2002 at 10:03 am
  • Dear everyone, I already installed oracle 8i database on my server, to make my system secured I changed my 'INTERNAL' password but I forget to write the changed in my book, and now I can't enter to ...
    Sony kristantoSony kristanto
    Dec 18, 2002 at 7:13 am
    Dec 20, 2002 at 2:08 am
  • Hi, This is the query bothered us very much recently. It run at least 15 min. and sometimes crashed the temp tablespace. Do you have any idea how to make it run better. Our developer tried used two ...
    Joan HsiehJoan Hsieh
    Dec 17, 2002 at 7:34 pm
    Dec 18, 2002 at 4:04 pm
  • List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server. He's using the install disk for Windows NT and 2000. Needless to say, it gives him an error ...
    Barbara BakerBarbara Baker
    Dec 17, 2002 at 11:34 pm
    Dec 18, 2002 at 11:58 am
  • Hey all, Does anyone have an idea as to how to tackle "single-task" message waits on 8.1.7? The most I could find on this is that it may have to do with Context indexes, which are referenced in the ...
    Jesse, RichJesse, Rich
    Dec 3, 2002 at 11:10 pm
    Dec 11, 2002 at 10:44 pm
  • This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or ...
    Dec 9, 2002 at 3:14 pm
    Dec 10, 2002 at 6:09 pm
  • Hi listers, Thanks for the comments to Dennis and Ron; I knew there was something wrong with that comment, but decided to ckeck it out with the list just in case :) thanks for your time! Saludos, ...
    Veronica LevinVeronica Levin
    Dec 2, 2002 at 4:34 pm
    Dec 6, 2002 at 8:59 pm
  • Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time..;) Is there any chance of another ...
    Mark LeithMark Leith
    Dec 3, 2002 at 9:59 am
    Dec 3, 2002 at 5:28 pm
  • Oracle has very good reason to have this role limitation. Â Suppose you have a role role_a. Through this role you have access to a table table_b. Now you create a procedure that accesses table_b. An ...
    Jamadagni, RajendraJamadagni, Rajendra
    Dec 25, 2002 at 5:28 pm
    Dec 27, 2002 at 8:43 am
Group Navigation
period‹ prev | Dec 2002 | next ›
Group Overview
grouporacle-l @

311 users for December 2002

Rachel Carmichael: 76 posts Jamadagni, Rajendra: 63 posts DENNIS WILLIAMS: 61 posts Yechiel Adar: 60 posts Jared.Still_at_radisys.com: 50 posts Khedr, Waleed: 39 posts Deshpande, Kirti: 36 posts Jared Still: 36 posts Koivu, Lisa: 36 posts Jonathan Lewis: 33 posts Stephen Lee: 33 posts Jeremy Pulcifer: 32 posts Mercadante, Thomas F: 30 posts Connor McDonald: 29 posts Shaleen Garg: 28 posts Fink, Dan: 27 posts Hkchital: 27 posts Ruth Gramolini: 27 posts Tim Gorman: 27 posts Boivin, Patrice J: 25 posts
show more