Search Discussions

482 discussions - 2,084 posts

  • List, i just finished writing a script to generate random data to populate tables for load testing... the script takes into account the check constraint of a column and generate the correct/valid ...
    Feb 18, 2002 at 6:28 am
    Feb 28, 2002 at 10:01 pm
  • I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have "his" data warehouse running within 24 hours, and we will use his design. 1 - We are ...
    Feb 27, 2002 at 6:48 am
    Feb 28, 2002 at 11:29 pm
  • Hi folks ! I have some constants value i want to show then in tabular format with two cloumns and n rows is it possible to get them through in that way by manipulating SQL statements i dont want to ...
    Feb 18, 2002 at 7:23 am
    Feb 28, 2002 at 7:58 pm
  • So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup & Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by ...
    Jesse, RichJesse, Rich
    Feb 7, 2002 at 11:29 pm
    Feb 26, 2002 at 8:51 pm
  • Hello DBAs Is there a command that tells me which rollback segment is being used by current transaction? Also, can you force a session to use particular rollback segment? I have used in the past the ...
    Witold IwaniecWitold Iwaniec
    Feb 18, 2002 at 3:33 pm
    Feb 28, 2002 at 3:33 pm
  • Okay... I am at a loss. There is SOMETHING wrong, and I can not for the life of me see it. I know there is something REALLY simple wrong with this, but I can't find it... ANYWHERE... and the error ...
    April WellsApril Wells
    Feb 14, 2002 at 1:55 pm
    Feb 14, 2002 at 5:59 pm
  • Hi I there any view which can tell us which indexes are not in use? Thx -Seema Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ ...
    Seema SinghSeema Singh
    Feb 4, 2002 at 6:02 pm
    Feb 6, 2002 at 12:42 pm
  • All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition ...
    SARKAR, SamirSARKAR, Samir
    Feb 12, 2002 at 10:54 am
    Feb 13, 2002 at 9:35 pm
  • During the class, I kept a list of all the "I can't believe this is really the case with SQL*Server..." items, and thought you might all like to see it. These are just notes I took on a Palm Pilot, ...
    Jim HawkinsJim Hawkins
    Feb 18, 2002 at 8:13 pm
    Feb 28, 2002 at 9:15 pm
  • Hi all, Our consultant has presented a schema design which I have never seen (not that I have seen all the designs in the world) but I also failed to see the advantage. Basically our application ...
    Oracle dbaOracle dba
    Feb 13, 2002 at 7:12 pm
    Feb 14, 2002 at 8:21 am
  • How about changing their password for the time being. Aleem -----Original Message----- Sent: Monday, February 18, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Subject: Disable certain users ...
    Abdul AleemAbdul Aleem
    Feb 18, 2002 at 8:53 am
    Feb 28, 2002 at 10:43 pm
  • I am going to be executing a long running job this weekend from home. I am going to VPN into the corp network and telnet to the server. I am affraid of loosing my telnet terminal session and the job ...
    Erik WilliamsErik Williams
    Feb 4, 2002 at 7:17 pm
    Feb 5, 2002 at 10:17 am
  • Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: New2orcl_at_aol.com Fat City Network ...
    Feb 6, 2002 at 7:07 pm
    Feb 8, 2002 at 5:59 am
  • Hi I want to send an email from Unix with an attachment .does anyone know how to do this? TIA
    Feb 1, 2002 at 7:04 pm
    Feb 5, 2002 at 6:28 am
  • Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with ...
    Post, EthanPost, Ethan
    Feb 7, 2002 at 10:38 pm
    Feb 8, 2002 at 8:25 pm
  • Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have ...
    Jonathan GennickJonathan Gennick
    Feb 1, 2002 at 2:40 am
    Feb 1, 2002 at 7:47 pm
  • Do I have to rebuild the controlfiles if I change any of the dump destinations in my oracle init.ora files. Thanks Darren Darren Browett P.Eng This message was transmitted Data Administrator using ...
    Browett, DarrenBrowett, Darren
    Feb 13, 2002 at 8:35 pm
    Feb 28, 2002 at 9:03 pm
  • Good morning all, It there a view which tell which tables are in parallel? I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ...
    Ruth GramoliniRuth Gramolini
    Feb 12, 2002 at 2:23 pm
    Feb 13, 2002 at 4:20 pm
  • I have a question on the export/import utility. I have my live(PROD) and test(TEST) databases are on the same server. These are basically the same schemas except that the data in TEST is old and that ...
    Farnsworth, DaveFarnsworth, Dave
    Feb 5, 2002 at 2:32 pm
    Feb 7, 2002 at 6:11 pm
  • Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de ...
    Alexander OrdonezAlexander Ordonez
    Feb 6, 2002 at 3:57 pm
    Feb 6, 2002 at 8:14 pm
  • I've read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i ...
    David WagonerDavid Wagoner
    Feb 19, 2002 at 8:04 pm
    Feb 28, 2002 at 5:08 pm
  • list, the management has asked me to report the activities i do to make sure that all the DB's are in perfect health.!! Without being technical the report should somehow show the status of the ...
    Feb 15, 2002 at 4:13 am
    Feb 18, 2002 at 5:43 am
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: ashoke.k.mandal_at_medtronic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San ...
    Mandal, AshokeMandal, Ashoke
    Feb 8, 2002 at 5:27 pm
    Feb 15, 2002 at 3:13 pm
  • Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing ...
    Rama MalladiRama Malladi
    Feb 7, 2002 at 1:41 am
    Feb 8, 2002 at 8:40 am
  • Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
    Feb 7, 2002 at 11:08 am
    Feb 8, 2002 at 1:27 am
  • The irony is that Microsoft plans to put a built-in rdbms in the OS that will come out two versions after .NET Server. The rdbms will be in the OS, not the other way around. Regards, Patrice Boivin ...
    Boivin, Patrice JBoivin, Patrice J
    Feb 1, 2002 at 2:58 pm
    Feb 1, 2002 at 9:24 pm
  • OS: redhat linux 7.2 DB: oracle 9.0.1 Issue: Databases startup but do not shutdown I placed the db startup and shutdown scripts in /etc/rc.d/init.d directories and linked them to rc0.d, rc2.d, rc3.d, ...
    Gene SaisGene Sais
    Feb 13, 2002 at 5:46 pm
    Feb 19, 2002 at 7:29 pm
  • Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild ...
    Fred SmithFred Smith
    Feb 12, 2002 at 3:59 pm
    Feb 12, 2002 at 10:38 pm
  • Hi All, i really need some papers on replication and any book recommendations. TiA!!!!!! -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET ...
    Bill ConnerBill Conner
    Feb 26, 2002 at 7:53 pm
    Feb 27, 2002 at 3:38 pm
  • Hi listers, How to convert the locally management tablespace back to dictionary management tablespace? I used dbms_space_admin migrated all the tablespaces to LMT. Now I want convert back on some ...
    Joan HsiehJoan Hsieh
    Feb 13, 2002 at 8:47 pm
    Feb 17, 2002 at 6:13 pm
  • We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same ...
    Peter BarnettPeter Barnett
    Feb 15, 2002 at 12:48 am
    Feb 15, 2002 at 9:09 pm
  • Hi G_DBA, The transaction id (which is recorded in the ITL) consists of 3 components. Undo Segment Number, Slot Number and Wrap Number. THe max value of the wrap number is limited by UB4MAXVAL ...
    K GopalakrishnanK Gopalakrishnan
    Feb 14, 2002 at 7:31 pm
    Feb 15, 2002 at 9:01 pm
  • Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema ...
    Kevin wangKevin wang
    Feb 6, 2002 at 8:28 pm
    Feb 7, 2002 at 10:38 pm
  • Hi everyone, Is one of these more correct than the other ? 1) select distinct customer_number, address_code from orders; 2) select customer_number, address_code from orders group by ...
    Seefelt, BethSeefelt, Beth
    Feb 6, 2002 at 3:05 pm
    Feb 6, 2002 at 9:47 pm
  • I am working through the book "OCP Intro to Oracle9i; SQL Exam Guide" by Jason Couchman. On page 6 they say to run the script utlsampl.sql to create objects. So, I have run it from the Command ...
    Feb 6, 2002 at 3:47 pm
    Feb 6, 2002 at 7:20 pm
  • 10


    Can anyone tell me what the OUTLN user is for? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith_at_kmg.com Fat City Network Services -- ...
    Smith, Ron L.Smith, Ron L.
    Feb 4, 2002 at 3:01 pm
    Feb 4, 2002 at 5:44 pm
  • I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full ...
    Bill BuchanBill Buchan
    Feb 27, 2002 at 12:43 pm
    Feb 28, 2002 at 10:48 am
  • Hi list, I have an urgent problem for startup database when I try to stratup database I get this error: ora-01122 database file 29 failed verification check ora-01110 data file 29 databaseQDX.dbf ...
    Hamid AlaviHamid Alavi
    Feb 14, 2002 at 7:03 pm
    Feb 15, 2002 at 9:59 pm
  • Hi How to make import fast except BUFFER size increase and big rollback segment if I am reorganising the database. Thanks -Seema Get your FREE download of MSN Explorer at ...
    Seema SinghSeema Singh
    Feb 13, 2002 at 11:21 pm
    Feb 15, 2002 at 12:09 am
  • Hi, Can anybody try this on 9i? set echo on alter session set optimizer_mode=choose; alter session set cursor_sharing=force; create table tb1 (f1 number(4)); insert into tb1 values (1999); insert ...
    Feb 8, 2002 at 10:59 pm
    Feb 15, 2002 at 12:07 am
  • Has anyone heard of Unidata DB. It's relational and from IBM. Thanks, Ken Janusz, CPIM
    Feb 14, 2002 at 3:00 pm
    Feb 14, 2002 at 6:14 pm
  • Has anyone done the following: Create a db using Oracle Loaded on an HP Server The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the ...
    Robert PegramRobert Pegram
    Feb 12, 2002 at 4:30 pm
    Feb 13, 2002 at 1:10 am
  • 9


    We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables ...
    April WellsApril Wells
    Feb 7, 2002 at 9:17 pm
    Feb 8, 2002 at 7:03 pm
  • Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not ...
    Jared StillJared Still
    Feb 2, 2002 at 5:01 pm
    Feb 4, 2002 at 6:08 pm
  • Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled "Database Clash"? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested ...
    Jesse, RichJesse, Rich
    Feb 28, 2002 at 4:53 pm
    Feb 28, 2002 at 10:31 pm
  • Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read ...
    Glenn TravisGlenn Travis
    Feb 26, 2002 at 7:38 pm
    Feb 26, 2002 at 11:09 pm
  • I am unable to drop a tablespace that I created. I created the tablespace with a lower case name, when I do a select * from dba_tablespaces the name is lowercase as opposed to uppercase. When I "drop ...
    Browett, DarrenBrowett, Darren
    Feb 20, 2002 at 8:18 pm
    Feb 20, 2002 at 10:24 pm
  • Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon ...
    CHAN Chor Ling Catherine (CSC)CHAN Chor Ling Catherine (CSC)
    Feb 18, 2002 at 7:28 am
    Feb 20, 2002 at 10:13 am
  • Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory ("shared pool","unknown ...
    Baker, BarbaraBaker, Barbara
    Feb 15, 2002 at 12:29 am
    Feb 15, 2002 at 6:34 pm
  • Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of ...
    Jason RowskiJason Rowski
    Feb 12, 2002 at 5:13 pm
    Feb 13, 2002 at 5:38 am
Group Navigation
period‹ prev | Feb 2002 | next ›
Group Overview
grouporacle-l @

377 users for February 2002

Jared.Still_at_radisys.com: 57 posts Rachel Carmichael: 56 posts Àãø éçéàì: 53 posts Dgoulet_at_vicr.com: 52 posts Stephane Faroult: 43 posts Deshpande, Kirti: 34 posts Mercadante, Thomas F: 33 posts Mohammad Rafiq: 30 posts DENNIS WILLIAMS: 29 posts Igor Neyman: 29 posts Bellows, Bambi: 28 posts Marin Dimitrov: 28 posts K Gopalakrishnan: 27 posts Connor McDonald: 25 posts Gogala, Mladen: 25 posts Babich , Sergey: 22 posts Ruth Gramolini: 21 posts Jesse, Rich: 20 posts Rick_Cale_at_teamhealth.com: 20 posts Khedr, Waleed: 18 posts
show more