Re: Order rows
Agree. We are talking the same things :) Alexandre Alexander, OK, we're splitting hairs here. :) Of course ROWID's are stored in indexes, the database has to be able to locate the rows. They are an internal mechanism and not part of the user data. And yes they can be used, and safely in certain situations. Updating a row in PL/SQL comes to mind. But they should never be stored in a table for other than temporary utility usage. Jared Alexandre Gorbatchev [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/16/2002 12:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Order rows Jared, Oracle gives you a chance to use it. And it's very common to use. Isn't it? There is no conception of phisical location in realational theory. I'm not saying that pure theory is the best for practical use, though. :) BTW, Oracle stores ROWID in indexes... instead of primary key (which is stored only in case of indexes on IOT). Of course, that's speed up access, but... Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 11:50 PM In fact ROWID is the Oracle implementation and against RDBMS rules. :) ROWID gives information about phisical location of the record. That MUST NOT be in PURE relational database. Nowadays, there is no pure relational database implementation. That doesn't really count, as Oracle does not store that as part of the data. It is generated from datafile and datablock information at runtime. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connecting to Oracle without using Listener
You have to use listener merely to establish (!) a connection. However, it can be configured on other port. Note, that listener redirects (in general) your connection to another port (to server process or to dispatcher), so client uses another port to communicate with server. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 5:33 AM Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP with or without using Listener at port 1521? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cache buffer chains
As well as endorsing Bruce's post, on a great many systems, the main cause of this style of contention is poor sql, where 'poor' means massive buffer gets due to either coding or executions. Take a look in v$sql and see if there are any obvious candidates. hth connor --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Oracle 8.0.5 Tru64 4.0f I was doing a stats pack analysis and noticed that we had latch problems. I drilled in a bit further and it would appear that the issue was down to cache buffer chains. The Metalink article (I was flying blind here) states To identify the heavily accessed buffer chain look at the latch stats for this latch under View:V$Latch_Children I did this and it came back with over 1 rows Can someone give me a little guidance here ?? Regards Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cache buffer chains
Thanks to all (again !!) -Original Message- Sent: 17 May 2002 10:08 To: Multiple recipients of list ORACLE-L As well as endorsing Bruce's post, on a great many systems, the main cause of this style of contention is poor sql, where 'poor' means massive buffer gets due to either coding or executions. Take a look in v$sql and see if there are any obvious candidates. hth connor --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Oracle 8.0.5 Tru64 4.0f I was doing a stats pack analysis and noticed that we had latch problems. I drilled in a bit further and it would appear that the issue was down to cache buffer chains. The Metalink article (I was flying blind here) states To identify the heavily accessed buffer chain look at the latch stats for this latch under View:V$Latch_Children I did this and it came back with over 1 rows Can someone give me a little guidance here ?? Regards Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Intelligent Enterprise Magazine - What's Next for the Database
http://www.intelligententerprise.com/020509/508feat1_1.shtml an interview with Stephen Brobst (NCR), Don Haderle (IBM), Ken Jacobs (Oracle) and Jeffrey Ullman (Stanford University) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Off-Topic - Maximum I-O Size of O.S.
Qs 1 What is the MAXimum I-O size on IBM AIX 4.3.3 5.L ? Is it Tunable ? Qs 2 Similarly What is the MAXimum I-O Size on Solaris 8 ? Is it Tunable by Setting maxphys , if so to What max Value ? NOTE - Checkign this to Compute Suitable RAID Stripe Width -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wait Event PX Deq: Execution Msg
I failed to mention this is an 8.1.7.3 database. Sorry about that. Nancy -Original Message- McCormick Sent: Thursday, May 16, 2002 7:53 PM To: Multiple recipients of list ORACLE-L Hello, I am hoping someone can help me with an elusive wait event called 'PX Deq: Execution Msg'. As you can see from the statspack Top 5 Wait Events this event accounts for almost 75% of the wait time. I have been looking in past Oracle-L posts, Google, Oracle FAQ, OTN, Metalink, Oracle manuals, etc. I can find almost nothing about this event. What I did find leads me to believe may be an idle event and that it is the second event 'PX Deq Credit: send blkd' that may be the more troublesome one. However I am still confused about both. Can someone help set me straight or tell me where there might be some more information about these 2 events? Thanks, Nancy Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - -- PX Deq: Execution Msg 42,1448,639,803 74.48 PX Deq Credit: send blkd 15,3392,878,443 24.81 log file parallel write41,934 30,787 .27 db file parallel write 8,776 25,046 .22 db file sequential read24,767 18,255 .16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Symbolic links, Raw device
I have heard of this occuring in the past on an IBM port, but do not recall the exact details. I think it had something to do with adding a link to a datafile belonging to another datbase, and that datbase was down at the time. It definitely resulted in a corrupt datbase (ugly recovery). However, a quick test on my 9i Sun system w/raw files reveals the following error when attempting to add the second data file to the same underlying file. SQL create tablespace x datafile '/d8100/dba/oracle/file1.dbf' size 100m; Tablespace created. SQL alter tablespace x add datafile '/d8100/dba/oracle/file2.dbf' size 100m; alter tablespace x add datafile '/d8100/dba/oracle/file2.dbf' size 100m * ERROR at line 1: ORA-01119: error in creating database file '/d8100/dba/oracle/file2.dbf' ORA-27086: skgfglk: unable to lock file - already in use SVR4 Error: 11: Resource temporarily unavailable Additional information: 8 Bill --- Sukumar Kurup [EMAIL PROTECTED] wrote: Hi, One of my friend is having a peculiar problem and will appreciate any help from this group. Is it possible for 2 symbolic links to point to the same raw device and be able to create both datafiles ? The following is the situation, experienced by him: There is a tablespace having (staging_d_03.dbf) which is a symbolic link to a raw device (/dev/vg02/rlvol19) . This datatafile is a part of tablespace STAGING_D. By mistake, another link was created (appusr_d27.dbf) pointing to the same raw device. 17 May 7 17:01 staging_d_03.dbf - /dev/vg02/rlvol19 17 May 15 15:09 appusr_d27.dbf - /dev/vg02/rlvol19 Now, he has been able to add this (appusr_d27.dbf) to another tablespace (APP_USERS) WITHOUT using the reuse clause . Is it possible ? (I do not have any raw device to test this, but tried creating symbolic links to the same file (on filesystem) and was,as expected, unable to add the existing datafile to another tablespace ) Further, he took the dump of the control file (alter database backup controlfile to trace;) and it is showing both the datafiles. He actually does not need the staging datafile any more, so can he just go ahead and drop the datafile (by recreating the STAGING_D tablespace ? What must be happening ? Is it possible that the file has been overwritten/corrupt ? Thanks Sukumar Kurup __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sukumar Kurup INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlldr
DIR=directory where the files live ls $DIR | while read FILE do sqlldr ... file=$DIR/$FILE ... done --- Ravindra [EMAIL PROTECTED] wrote: We have a process that generates log file continously with dateandtime stamp on the filename like log_041502_113545.log These log files should be loade to the table using sql loader.I have the sqlldr script to load to the table.But this sqlldr will be part of the shell script that is will be executed as cron job on the unix server. How can I read the varying file name in the sqlldr command and automate the sqlldr job. thanks Ravi __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] How to make Sql*loader run under nologging mode?
Or if you want the loaded data to be recoverable :) Also, you will find some nasty side affects when using direct sql load (indexes are invalidated at the end for rebuild). Of course you can use the skip_unusable_indexes parameter to get around concurrent query errors (this feature has been known to have bugs). You may also want to consider loading into a table, building indexes, and then doing a partition exchange. Bill --- Miller, Jay [EMAIL PROTECTED] wrote: And of course you shouldn't do this if you're running with a standby database. Jay Miller -Original Message- Sent: Wednesday, May 15, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Command line option DIRECT=Y Control file option UNRECOVERABLE --- dist cash [EMAIL PROTECTED] wrote: We have ORACLE 8.1.7.2 version running on SUn Solaris. The ORACLE running under archive log mode. everytime we use Sql*loader to load data, it will generate a lot of archive logs. Does their has way to make sql*loader run under nologging mode? Thanks. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Errors while relinking on Redhat Hat (Oracle9i)
this should fix yr problem. EITHER you downgrade binutils rpm -Uvh --force --nodeps binutils-2.10.0.18-1.i386.rpm (in case you don't have it from rh70 get it from ftp.redhat.com) and try to relink OR # vi $ORACLE_HOME/bin/genclntsh search for the line: LD_SELF_CONTAINED=-z defs and edited so that it reads LD_SELF_CONTAINED= after that started entered # cd $ORACLE_HOME/bin/ # relink all [EMAIL PROTECTED] 05/17/02 06:34 AM Hi, The install of Oracle9i on Redhat 7.2 went well but had problems during the relinking phase. When tried to relink the binaries manually, I am getting errors such as- /lib/libc.so.6: undefined reference to '__cmpdi1' /lib/libc.so.6: undefined reference to '[EMAIL PROTECTED]' Could you please help me in fixing this problem. THanks for your help and time in advance. Regards CP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Connecting to Oracle without using Listener
if your real question is can I circumvent the listener, the answer is no. Keith Date: Thu, 16 May 2002 19:33:46 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP with or without using Listener at port 1521? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wait Event PX Deq: Execution Msg
Nancy: From your message the average wait time is less than 1 micro second (if I my undertstanding is correct) and I would not worry much about that if that is the case. Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 6:53 PM I failed to mention this is an 8.1.7.3 database. Sorry about that. Nancy -Original Message- McCormick Sent: Thursday, May 16, 2002 7:53 PM To: Multiple recipients of list ORACLE-L Hello, I am hoping someone can help me with an elusive wait event called 'PX Deq: Execution Msg'. As you can see from the statspack Top 5 Wait Events this event accounts for almost 75% of the wait time. I have been looking in past Oracle-L posts, Google, Oracle FAQ, OTN, Metalink, Oracle manuals, etc. I can find almost nothing about this event. What I did find leads me to believe may be an idle event and that it is the second event 'PX Deq Credit: send blkd' that may be the more troublesome one. However I am still confused about both. Can someone help set me straight or tell me where there might be some more information about these 2 events? Thanks, Nancy Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- -- -- PX Deq: Execution Msg 42,1448,639,803 74.48 PX Deq Credit: send blkd 15,3392,878,443 24.81 log file parallel write41,934 30,787 .27 db file parallel write 8,776 25,046 .22 db file sequential read24,767 18,255 .16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQLPlus was Oracle - can you imagine ;-)
ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
Have you been on the sauce ??? -Original Message- Sent: 17 May 2002 15:54 To: Multiple recipients of list ORACLE-L ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connecting to Oracle without using Listener
You can connect directly to a dispatcher you have started on a different port. No listener required. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 17 May 2002, Keith Peterson wrote: if your real question is can I circumvent the listener, the answer is no. Keith Date: Thu, 16 May 2002 19:33:46 -0800 To: Multiple recipients of list ORACLE-L Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP with or without using Listener at port 1521? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to replace it? Tom Xie -Original Message- Sent: Wednesday, May 15, 2002 11:25 AM To: [EMAIL PROTECTED] There is absolutely NO WAY to drop a datafile from a tablespace at all. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/15/02 09:58 AM Please respond to ORACLE-L Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this file. I found that there is no data in this file yet. So I want to drop the file from the tablespace. As I know, to drop a data file, I have to export the data, drop the tablespace and recreate it, and then import data back to the tablespace. However, since our users can't stop using the table, I won't have enough down time to do that. Is there anyway I can quickly drop a data file from a tablespace? Don't tell me using alter database datafile '...' offline drop command. It won't work. I am working on Oracle 7.3.4. Thanks, Tom Xie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Re: SQLPlus was Oracle - can you imagine ;-)
Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: SQLPlus was Oracle - can you imagine ;-)
OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Errors while relinking on Redhat Hat (Oracle9i)
On Thu, May 16, 2002 at 08:58:18PM -0800, CP wrote: The install of Oracle9i on Redhat 7.2 went well but had problems -- RH 7.2 isn't supported by Oracle, in case it matters. The RH monkies ticked Larry off. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Microsoft Transaction Server Standby database problem
When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a red light across a 4 lane highway?? Good to see you again. -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Tom, If you lost an archivelog from the time this datafile was created to present time. There is no way to simply offline that file and recover that file. It will become a classic case of performing incomplete recovery then. Glad that it works out for you! :D WInnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 08:38 AM Please respond to ORACLE-L Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to replace it? Tom Xie -Original Message- Sent: Wednesday, May 15, 2002 11:25 AM To: [EMAIL PROTECTED] There is absolutely NO WAY to drop a datafile from a tablespace at all. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/15/02 09:58 AM Please respond to ORACLE-L Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this file. I found that there is no data in this file yet. So I want to drop the file from the tablespace. As I know, to drop a data file, I have to export the data, drop the tablespace and recreate it, and then import data back to the tablespace. However, since our users can't stop using the table, I won't have enough down time to do that. Is there anyway I can quickly drop a data file from a tablespace? Don't tell me using alter database datafile '...' offline drop command. It won't work. I am working on Oracle 7.3.4. Thanks, Tom Xie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: How to drop a datafile from a tablespace quickly
Tom, If you lost an archivelog from the time this datafile was created to present time. There is no way to simply offline that file and recover that file. It will become a classic case of performing incomplete recovery then. Glad that it works out for you! :D WInnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 08:38 AM Please respond to ORACLE-L Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to replace it? Tom Xie -Original Message- Sent: Wednesday, May 15, 2002 11:25 AM To: [EMAIL PROTECTED] There is absolutely NO WAY to drop a datafile from a tablespace at all. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/15/02 09:58 AM Please respond to ORACLE-L Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this file. I found that there is no data in this file yet. So I want to drop the file from the tablespace. As I know, to drop a data
RE: Oracle RDB vs. Plain Oracle
I remember that Oracle reportedly paid DEC 100 million for the product mainly for the technology a lot of which has subsequently appeared in Oracle RDBMS. To add to the list... log miner I believe has it's roots in Oracle RDB, also locally managed tablespaces. Oracle RDB has managed space in a similar fashion as LMT (not quite the same but same concepts) for probably a decade now. Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 11:43 PM To: Multiple recipients of list ORACLE-L Oracle has two database products, Oracle RDBMS, (or oracle oracle) and Oracle Rdb. Both of them are relational databases. However, Oracle Rdb only supported on Open VMS. Oracle purchased Oracle Rdb (previously called DEC Rdb) from Digital equipment corporation several years before. this is a great production and scales pretty well. Many of the large OLTP implementations use Rdb, eg.. Australian Stock Exchange, Korean Stock Exchange, Mercantile Bank, DIRECTV, etc to name a few. Many of the features you are seeing today with Oracle, existed in Rdb for several years now (partitioning, multi block format) etc. and have moved into the Oracle space from Oracle Rdb after Oracle purchased this product. Actually the cost based optimizer is another good example, and Oracle Expert, new features in Data guard etc. Need more specifics visit http://www.oracle.com/rdb Regards, Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 16 May 2002 18:58:24 -0800 Hello, What are the differences between the two? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Murali Vallath Oracle Certified DBA http://www8.ewebcity.com/muralivallath/ http://www.summerksyus.com/ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Platinum Fastunloader
Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
oracle 8.0.5.1 on hpux 11.11
Title: oracle 8.0.5.1 on hpux 11.11 Has anyone got this combination working? I'm aware of the fact that it is not certified or supported, but 7.3.4.4 is working on 11.11, and at least temporarily, I need 8.0.5.1 too. But I get a ora-3113 (and a ORA-7445 [10] in the trace file) every time I run svrmgrl. Anybody done this before? Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals
MTS questions
Hey list, It's been awhile since I've used MTS, and some questions have come up regarding it. The question revolves around sniped sessions, and the need to remove these things automatically in some systems, since they consume resources. Such as a DW where sessions may not be created very frequently. Doing this with dedicated servers is no problem. Doing so with MTS is another matter. When I kill a sniped session, I first kill the OS process ( or thread ) and then kill the session, if it is still around. I kill the OS process first due to an infamous problem with Oracle. When you kill a session that is holding locks, there's a chance that this session will never go away until the DB is bounced. And it continues to hold the lock until the DB is bounced. I've had this happen on multiple versions of Oracle, on Solaris, DG/UX and Windoze NT. The question is: What is the process that appears in V$PROCESS for an idle session that is connected via MTS? I'm guessing it's the dispatcher. I don't have anyway to check this however. Any help in this would be greatly appreciated. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
You mean that 40% A/V - 80%proof was not ketchup...? and the most complex question for the group in those days would have been: I am new to Oracle and I have this problem SQL desc emp NameNull?Type --- EMPLOYEE_ID NUMBER(4) LAST_NAMEVARCHAR2(15) FIRST_NAME VARCHAR2(15) MIDDLE_INITIAL VARCHAR2(1) JOB_ID NUMBER(3) MANAGER_ID NUMBER(4) HIRE_DATEDATE SALARY NUMBER(7,2) COMMISSION NUMBER(7,2) DEPARTMENT_IDNUMBER(2) FAT/TITLEVARCHAR2(40) SQL select fat/title 2 from emp; select fat/title * ERROR at line 1: ORA-00904: invalid column name SQL c/fat\/\title/FAT/TITLE String not found. SQL drop the employees fat/title; drop the employees fat/title * ERROR at line 1: ORA-00950: invalid DROP option SQL huh? unknown command huh? - rest of line ignored. SQL Keith Date: Fri, 17 May 2002 07:18:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] ;-) Organization: Fat City Network Services, San Diego, California Have you been on the sauce ??? -Original Message- Sent: 17 May 2002 15:54 To: Multiple recipients of list ORACLE-L ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLPlus was Oracle - can you imagine ;-)
ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: SQLPlus was Oracle - can you imagine ;-)
I believe, fifteen years ago, it had already changed to SQL. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there and probably the Oracle pre-compilers for 3GL's as well. As someone who has been an Oracle DBA since 1984, I can only say Keith's understanding of the Oracle RDBMS, 'About 15 years ago, Sqlplus WAS Oracle' Nothing else. differs radically from the conventional view. I believe the first responder was on track, with his imbibing query. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 17, 2002 9:28 AM To: Multiple recipients of list ORACLE-L OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
One of our users called UFI User Surly Interface. -Original Message- Sent: Friday, May 17, 2002 12:38 PM To: Multiple recipients of list ORACLE-L ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Umm.. couple of things to verify... First, yes, it is me again! Second, the U-Turn was done on a yellow light (at least that is what I see that night!) Third, that is just a LA street, not a highway! :P Forth, this is not wild... just LA type of driving! Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Grabowy, Chris [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 09:58 AM Please respond to ORACLE-L Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a red light across a 4 lane highway?? Good to see you again. -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Tom, If you lost an archivelog from the time this datafile was created to present time. There is no way to simply offline that file and recover that file. It will become a classic case of performing incomplete recovery then. Glad that it works out for you! :D WInnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 08:38 AM Please respond to ORACLE-L Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to
RE: How to drop a datafile from a tablespace quickly
Yeah, I have missed every OOW since then. Just not worth it compared to IOUG. I could have sworn I saw some Perl-looking DBA standing on the corner with his eyes wide and mouth hanging open when she flung that car and her passengers around. BTW, when is that Perl/Oracle DBA book coming out. Heck, I'm still trying to figure out how to write a loop in Perl...can't I just replace all those strange characters with words? -Original Message- Sent: Friday, May 17, 2002 12:17 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Yeah, that's her! I fortunately missed that little excursion. I believe that I was a pedestrian that evening. ;) Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to drop a datafile from a tablespace quickly Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a red light across a 4 lane highway?? Good to see you again. -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Tom, If you lost an archivelog from the time this datafile was created to present time. There is no way to simply offline that file and recover that file. It will become a classic case of performing incomplete recovery then. Glad that it works out for you! :D WInnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 08:38 AM Please respond to ORACLE-L Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to replace it? Tom Xie -Original Message- Sent: Wednesday, May 15, 2002 11:25 AM To: [EMAIL PROTECTED] There is absolutely NO WAY to drop a datafile from a tablespace at all. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/15/02 09:58 AM Please respond to ORACLE-L Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this file. I found that there is no data in this file yet. So I want to drop the file from the tablespace. As I know, to drop a data file, I have to export
Re:MTS questions
Jared, If you look in V$process and V$session you'll see that there are only a limited number of processes and that as you surmised the dispatcher points back to the idle sessions it is dealing with. Now if the session becomes active that changes to the shared server doing the work. And if the session connects via dedicated server, from yesterday's thread, then it's as you know it today without MTS. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 5/17/2002 9:13 AM Hey list, It's been awhile since I've used MTS, and some questions have come up regarding it. The question revolves around sniped sessions, and the need to remove these things automatically in some systems, since they consume resources. Such as a DW where sessions may not be created very frequently. Doing this with dedicated servers is no problem. Doing so with MTS is another matter. When I kill a sniped session, I first kill the OS process ( or thread ) and then kill the session, if it is still around. I kill the OS process first due to an infamous problem with Oracle. When you kill a session that is holding locks, there's a chance that this session will never go away until the DB is bounced. And it continues to hold the lock until the DB is bounced. I've had this happen on multiple versions of Oracle, on Solaris, DG/UX and Windoze NT. The question is: What is the process that appears in V$PROCESS for an idle session that is connected via MTS? I'm guessing it's the dispatcher. I don't have anyway to check this however. Any help in this would be greatly appreciated. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Just make sure you have a good recovery plan! Waleed -Original Message- Sent: Friday, May 17, 2002 2:01 PM To: Multiple recipients of list ORACLE-L Umm.. couple of things to verify... First, yes, it is me again! Second, the U-Turn was done on a yellow light (at least that is what I see that night!) Third, that is just a LA street, not a highway! :P Forth, this is not wild... just LA type of driving! Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Grabowy, Chris [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 09:58 AM Please respond to ORACLE-L Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a red light across a 4 lane highway?? Good to see you again. -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Tom, If you lost an archivelog from the time this datafile was created to present time. There is no way to simply offline that file and recover that file. It will become a classic case of performing incomplete recovery then. Glad that it works out for you! :D WInnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/17/02 08:38 AM Please respond to ORACLE-L Thanks, Winnie! It works. I have a further quetion. If the archivelogs from time when the file was created to current were lost, do we still have someway to bring the file online? Tom -Original Message- Sent: Wednesday, May 15, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Umm.. Try this: 1) ALTER DATABASE DATAFILE 'filename' OFFLINE; 2) get rid of the offended datafile from OS 3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)'; 4) RECOVER DATAFILE 'filename'; 5) ALTER DATABASE DATAFILE 'filename' ONLINE; Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] om cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: How to drop a datafile from a tablespace quickly 05/15/02 09:32 AM Since there is no data in the file, can we make a datafile to replace it? Tom Xie -Original Message- Sent: Wednesday, May 15, 2002 11:25 AM To: [EMAIL PROTECTED] There is absolutely NO WAY to drop a datafile from a tablespace at all. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--o Infonet Services Corporation `~`~ # mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Xie, Tom [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: How to drop a datafile from a tablespace quickly [EMAIL PROTECTED] 05/15/02 09:58 AM Please respond to ORACLE-L
Re:MTS questions
Thanks Dick, that's the way I thought it worked. Jared [EMAIL PROTECTED] 05/17/2002 10:00 AM To: [EMAIL PROTECTED], Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:MTS questions Jared, If you look in V$process and V$session you'll see that there are only a limited number of processes and that as you surmised the dispatcher points back to the idle sessions it is dealing with. Now if the session becomes active that changes to the shared server doing the work. And if the session connects via dedicated server, from yesterday's thread, then it's as you know it today without MTS. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 5/17/2002 9:13 AM Hey list, It's been awhile since I've used MTS, and some questions have come up regarding it. The question revolves around sniped sessions, and the need to remove these things automatically in some systems, since they consume resources. Such as a DW where sessions may not be created very frequently. Doing this with dedicated servers is no problem. Doing so with MTS is another matter. When I kill a sniped session, I first kill the OS process ( or thread ) and then kill the session, if it is still around. I kill the OS process first due to an infamous problem with Oracle. When you kill a session that is holding locks, there's a chance that this session will never go away until the DB is bounced. And it continues to hold the lock until the DB is bounced. I've had this happen on multiple versions of Oracle, on Solaris, DG/UX and Windoze NT. The question is: What is the process that appears in V$PROCESS for an idle session that is connected via MTS? I'm guessing it's the dispatcher. I don't have anyway to check this however. Any help in this would be greatly appreciated. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
It's been kind of slow today !! everybody seems to be working hard. 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 ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, May 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Platinum Fastunloader
Where I used to work, they had it will it was still Platinum (before CA took over). It was a decent product, but CA did not provide good support and was always YEARS behind. When we wanted to upgrade the DB from 7.3.4 to 8.1.6 (in late 2000), we found out that CA did not have a version of FastUnload certified to work with any version of Oracle 8. Granted, that was over a year and a half ago, but I'd bet they don't have a version for 9 ready yet either. If you go with it, good luck on getting decent support from CA. -Original Message- Sent: Friday, May 17, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLPlus was Oracle - can you imagine ;-)
MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
-It's been kind of slow today !! everybody seems to be working hard. Not me, I'm goofing off! :o) Dave -Original Message- Sent: Friday, May 17, 2002 2:08 PM To: Multiple recipients of list ORACLE-L It's been kind of slow today !! everybody seems to be working hard. 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 ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, May 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
It must be the Friday ritual and everyone is on the OT list today. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/17/02 03:08PM It's been kind of slow today !! everybody seems to be working hard. 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 ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, May 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
the sun's out in the northeast US. I'd guess people took the day off! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 17, 2002 3:08 PM To: Multiple recipients of list ORACLE-L It's been kind of slow today !! everybody seems to be working hard. 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 ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, May 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
Oracle5 had something called something like SQL*Star (can't remember exactly if that is correct name though!) that I used to interface Oracle with a McDonnelDouglas Hierarchical GDS system - about 17 years ago... What fond memories we are dragging up! Regards, Melanie Burns -Original Message- Sent: Friday, May 17, 2002 2:28 PM To: Multiple recipients of list ORACLE-L MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Root, Melanie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: SQLPlus was Oracle - can you imagine ;-)
What it was called locally when I started using it is not usable in mixed company. Dick Goulet Reply Separator Author: Schilling; Ben [EMAIL PROTECTED] Date: 5/17/2002 10:04 AM One of our users called UFI User Surly Interface. -Original Message- Sent: Friday, May 17, 2002 12:38 PM To: Multiple recipients of list ORACLE-L ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Platinum Fastunloader
Terry, Set Flames on Would you mind not cursing on the list. CA is a 4 letter word around here, just for the reason's you cite. The other is that they make Oracle look cheap. Set flames off Dick Goulet Reply Separator Author: Ball; Terry [EMAIL PROTECTED] Date: 5/17/2002 11:18 AM Where I used to work, they had it will it was still Platinum (before CA took over). It was a decent product, but CA did not provide good support and was always YEARS behind. When we wanted to upgrade the DB from 7.3.4 to 8.1.6 (in late 2000), we found out that CA did not have a version of FastUnload certified to work with any version of Oracle 8. Granted, that was over a year and a half ago, but I'd bet they don't have a version for 9 ready yet either. If you go with it, good luck on getting decent support from CA. -Original Message- Sent: Friday, May 17, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Do you ever have days where you dont want to think ?
I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Platinum Fastunloader
Platinum no longer exist - they now belong to Computer Associates (CA). CA still sell a product call Tsreorg (which had fast unload bundled into it). I am not sure if CA sell Fast unloan on its own. To be honest it wasn't a great selling product at Platinum on its own, but Tsreorg sold plenty with Fast unload bundled into it. - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Friday, May 17, 2002 6:38 PM Subject: Platinum Fastunloader Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: RE: SQLPlus was Oracle - can you imagine ;-)
No, not old... we were all preteens when we started with Oracle, remember! Well thats my story and I am sticking to it! Enough nostaglia for me! Regards, Melanie Burns -Original Message- Sent: Friday, May 17, 2002 12:38 PM To: Multiple recipients of list ORACLE-L ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: OK Keith, do you remember what the prompt was that SQL*Plus came up with back them what it stood for?? Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 5/17/2002 8:03 AM Yes, I can. 4 years ago I was porting our product to MS SQL 6.5 platform. JP On Fri 17. May 2002 16:53, you wrote: ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Root, Melanie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: SQLPlus was Oracle - can you imagine ;-)
Stephane, I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole lot more efficient than iag/iap. Damn, those were the days when a mouse was an optional item on your desktop that normally outlived the rest of the PC. That is IF you had a PC!! Dick Goulet Reply Separator Author: MacGregor; Ian A. [EMAIL PROTECTED] Date: 5/17/2002 12:18 PM I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
It's not using the index because of the NOT IN - it doesn't help to search an index to see what's NOT in it. Did you try rewriting it to use a NOT EXISTS instead? Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsh, Gary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Are people receiving postings
Yep... Got it. Lon Madhavan Amruthur wrote: Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lon White INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle version usage
At a recent NYOUG meeting the question was asked of of around 150 or so attendees (very rough estimate) how many had 9i on a production system. Two people raised their hands. Jay Miller -Original Message- Sent: Tuesday, May 14, 2002 7:44 PM To: Multiple recipients of list ORACLE-L I am especially interested in percentage of 7.3 and 8.0 installation. Maybe it is a good idea to mail me directly and I then will post the results. Alex Hillman -Original Message- Hillman Sent: Monday, May 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Platinum Fastunloader
Sounds like the old Platinum guys should start a support company of the old products... The biggest problem is that most of the techies left platinum (product developers) and joined - wait for it - Quest... after CA took them over. Now u know why the quest products work so well... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:18 PM Where I used to work, they had it will it was still Platinum (before CA took over). It was a decent product, but CA did not provide good support and was always YEARS behind. When we wanted to upgrade the DB from 7.3.4 to 8.1.6 (in late 2000), we found out that CA did not have a version of FastUnload certified to work with any version of Oracle 8. Granted, that was over a year and a half ago, but I'd bet they don't have a version for 9 ready yet either. If you go with it, good luck on getting decent support from CA. -Original Message- Sent: Friday, May 17, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee 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 message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clint Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Storing phone info...
Curious how people are storing phone info in their database, eg., separate columns for country code, city code, area code, etc. Any references about this would be appreciated! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
-- Kirsh, Gary [EMAIL PROTECTED] It's not using the index because of the NOT IN - it doesn't help to search an index to see what's NOT in it. Did you try rewriting it to use a NOT EXISTS instead? Which can quickly degenerate into a tablescan also... even if the index exists if the entropy isn't high enough oracle will skip it anyway. Try an analyze table first on the exists (or a sub-query) and see how that works. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
Johnson, Michael wrote: I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike I don't think that lying naked on a beach would help, but hints and the like could. I presume that table1 is pretty big. Larry Elkins could tell you that the HASH_AJ hint inside the subquery could work wonders. Another usually efficient solution (which in facts often boils down to the same thing as the hash anti-join hint in terms of execution plan) would be select a.f1, a.f2, a.f3, a.f4 from table1 a, b where a.f1 = b.n1 (+) and b.n1 is null Something else which could be contemplated if f1 is indexed could be select a.f1, a.f2, a.f3, a.f4 from (select f1 from table1 minus select n1 from b) a2, table1 a where a.f1 = a2.f1 Might require the ORDERED hint. I cannot tell you 'this is the best', depends on volumes searched and volumes returned, but one of those things might work well in your case. And ignore any advice to use NOT EXISTS unless you have an additional pretty selective condition on table1. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Try... select a.f1, a.f2, a.f3, a.f4 from table1 a where not exists (select b.n1 from b where b.n1 = a.f1); Let me know... Chris -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Storing phone info...
As for the adress, you have more flexibility when storing each parts separately. Stephane --- Suzy Vordos [EMAIL PROTECTED] a écrit : Curious how people are storing phone info in their database, eg., separate columns for country code, city code, area code, etc. Any references about this would be appreciated! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
I'm not sure an index would ever be used with not in (in seems to be bad enough). Not exists would probably be quicker though it'd probably be reasonable still to do a full table scan of a. Personally I prefer the likes of minus though it'd be a bit convoluted here e.g. select a.f1, a.f2, a.f3, a.f4 from a, (select a.f1 from table1 a minus select b.n1 from b) s where a.f1 = s.f1 -Original Message- Sent: Friday, May 17, 2002 10:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Title: RE: Do you ever have days where you dont want to think ? Mike, WheretheheckisOLN-AFMC? Okie City? Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index. Have you tried a hint? select /*+ index(table1 Table1_PK_indexname) */ a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); My assumption is that you have a performance problem. How many records and how long does it take? Maybe show us the entire explain plan? Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Johnson, Michael [SMTP:[EMAIL PROTECTED]] I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike
AQ using a trigger?
Does anyone have experience with AQ tables? I would like to put a trigger on my AQ table so that when a message comes in, it will automatically fire off a job to dequeue the message. I opened a TAR and was told that I can put a trigger on the table, but it's not recommended. When I asked why, they said 'it just wasn't recommended'. I'm curious if anyone actually knows why I shouldn't or if I really can. It really seems to be a slick way to handle the messages, but if it will cause problems, I'd like to know that upfront. Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLPlus was Oracle - can you imagine ;-)
[EMAIL PROTECTED] wrote: Stephane, I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole lot more efficient than iag/iap. Damn, those were the days when a mouse was an optional item on your desktop that normally outlived the rest of the PC. That is IF you had a PC!! Dick Goulet Older than I thought then. That was the time when computers were real computers. Never trust a machine you can lift (dare I say what I think of pocket PCs ?). I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] Ian, it was just for the sake of arguing :-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Storing phone info...
-- Suzy Vordos [EMAIL PROTECTED] Curious how people are storing phone info in their database, eg., separate columns for country code, city code, area code, etc. Any references about this would be appreciated! Useful for fast scans by a/c or prefix. Depends on the use. Indexes on these are usually a waste (not specific enough) but for a count(*) by a/c it beats having to substr the entire thing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
Yeah, I have those days. The beach sounds good; don't worry, I'll go find my own. Wouldn't want to frighten the natives. Try 'not exists', 'not in' forces a table scan. Even better, use an explicit anti-join. select a.f1, a.f2, a.f3, a.f4 from table1 a, table2 b where a.f1 = b.n1(+) and b.n1 is null; I learned this from Larry Elkins, I *think* I did it properly. Rather clever I thought. Jared Johnson, Michael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Do you ever have days where you dont want to think ? I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle version usage
On Fri, May 17, 2002 at 02:03:25PM -0800, Miller, Jay wrote: At a recent NYOUG meeting the question was asked of of around 150 or so attendees (very rough estimate) how many had 9i on a production system. Two people raised their hands. -- similar experience at Atlantic Oracle Training Conference a few weeks ago in D.C. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Sorry I dont want to think!! -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: SQLPlus was Oracle - can you imagine ;-)
Stephane, Understood boy do I agree. I was under the impression that these machines were created to server us, not the other way around!! Dick Goulet Reply Separator Author: Stephane Faroult [EMAIL PROTECTED] Date: 5/17/2002 2:28 PM [EMAIL PROTECTED] wrote: Stephane, I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole lot more efficient than iag/iap. Damn, those were the days when a mouse was an optional item on your desktop that normally outlived the rest of the PC. That is IF you had a PC!! Dick Goulet Older than I thought then. That was the time when computers were real computers. Never trust a machine you can lift (dare I say what I think of pocket PCs ?). I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] Ian, it was just for the sake of arguing :-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unicode output
Hello all, We're running Oracle RDBMS 8.1.7.2 on a Solaris 2.8 server platform. The development team for a particular project has written a stored procedure for sending data feeds to other projects. It spools outputs of queries to UTL_FILE_DIR, and then other processes E-mail the output files to vearious recipients. This database has international users. The NLS_LANG setting is AMERICAN_AMERICA.UTF8. Up until now all of the output files have looked fine, but recently an end-user in Mexico has inputted an address that looks in part like this: México It should look like Mexico with an accent above it ... The recipients of this particular spool file are complaining that this output is wrong, which I guess it is, from their perspective. Does anyone have any suggestions on a setting or process that could correct this, or somehow filter the output, or a workaround? I wish that the recipients could connect to the database directly, query the data they need and pull it into their own database, but that isn't how things are structured with this client. Any suggestions would be welcome. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
Don't have time to help with the query but following this link may help with the first part: http://images.google.com/images?hl=enlr=q=naked+beach (you military guys, one tract minds...lol) Brian P. MacLean Oracle DBA, OCP8i Johnson, Michael Michael.Johnson@oln-aTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fmc.af.mil cc: Sent by: Subject: Do you ever have days where you dont want to think ? [EMAIL PROTECTED] 05/17/02 02:23 PM Please respond to ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Microsoft Transaction Server Standby database problem
prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) = points to primary db (address=...) = points to standby db ) (connect_data=(service_name=prod) ) ) The ADDRESS_LIST= stuff has worked since the 7.2 time-frame, though I think the FAILOVER= and LOAD_BALANCE= syntax was added with 8.0; it was just for failover functionality originally. Of course, the SERVICE_NAME= stuff didn't happen until Oracle8i; before that it was SID= only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a sniper process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX halt command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next ADDRESS= entry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:33 AM When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are people receiving postings
Its out in the NW also, which is even more amazing considering the time of year. -Original Message- Thomas F Sent: Friday, May 17, 2002 12:38 PM To: Multiple recipients of list ORACLE-L the sun's out in the northeast US. I'd guess people took the day off! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 17, 2002 3:08 PM To: Multiple recipients of list ORACLE-L It's been kind of slow today !! everybody seems to be working hard. 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 ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, May 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: SQLPlus was Oracle - can you imagine ;-)
It was ODL : Oracle Data Loader . --- paquette stephane [EMAIL PROTECTED] a écrit : Since we're in old stuff. Anybody remember the ancestor of Sql*loader ? Answers in 10 minutes ! --- [EMAIL PROTECTED] a écrit : Stephane, I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole lot more efficient than iag/iap. Damn, those were the days when a mouse was an optional item on your desktop that normally outlived the rest of the PC. That is IF you had a PC!! Dick Goulet Reply Separator Author: MacGregor; Ian A. [EMAIL PROTECTED] Date: 5/17/2002 12:18 PM I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Do you ever have days where you dont want to think ?
The beach part sounds great, though I don't care to see naked men running around ;-) But it still beats doing this techie thing all the time. FWIW, a NOT IN *can* use an index under the CBO, and has done so since early 7, behaving very much like a correlated NOT EXISTS with a slight difference for nulls handling. Then in 7.3.2 when you could hint a hash_aj, or, set always_anti_join to hash (or merge), it could drift away from a correlated approach, using a hash or merge anti-join, *if* that was the appropriate approach. Maybe using an FTS, or an index fast full scan, or an index full scan. And whether to correlate or not depends on the data and the query, it's criteria, data, etc. And the MINUS operator is always an option that works well in some cases. The outer join and key is null trick that Stephane and Jared showed can be *very* useful. I can't remember where I first saw that trick, but I know Guy Harrison's SQL Tuning book, first edition, discusses it. I had seen it prior to that, but Harrison's book is at least one reference to the technique that I know of. And there are quite a few people who use the trick. It is especially useful when you *don't* want a correlated approach but the requirement for being able to use a hash-aj can't be met -- I had to use it on Thursday. Dropped that baby from 38 minutes to under a minute using the outer join and key is null trick along with a hash join outer approach. 9i is interesting because while the NOT EXISTS uses the correlated approach in 8i and earlier, which, depending upon the case, may or may not be a killer on performance, 9i can un-correlate it and use a hash-aj (or merge-aj), *if appropriate*. This isn't possible in 8i or below. So, it can very well take both a NOT EXISTS and NOT IN and make them hash-aj's. I hope the CBO makes the right decision for us ;-) Right now on a DW and a few DM's I deal with on 8.1.7, always_anti_join is set to hash -- that way if I want a correlated approach I use the NOT EXISTS. If the correlated approach is *not* the best approach, I can use a NOT IN and let the hash-aj come into play. Ok, off to the travel web sites, you folks got me thinking about beaches, islands, and water. Oh well, here is an example of a NOT EXISTS getting the hash-aj treatment under 9i: SQL select * 2 from code_master 3 where not exists (select null 4from code_detail 5where code_master.code = code_detail.code) 6 / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=770 Card=100 Bytes=1500) 10 HASH JOIN (ANTI) (Cost=770 Card=100 Bytes=1500) 21 TABLE ACCESS (FULL) OF 'CODE_MASTER' (Cost=77 Card=10 Bytes=110) 31 INDEX (FAST FULL SCAN) OF 'CD_CODE_IDX' (NON-UNIQUE) (Cost=208 Card=299600 Bytes=1198400) Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, May 17, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Do you ever have days where you dont want to think ? Yeah, I have those days. The beach sounds good; don't worry, I'll go find my own. Wouldn't want to frighten the natives. Try 'not exists', 'not in' forces a table scan. Even better, use an explicit anti-join. select a.f1, a.f2, a.f3, a.f4 from table1 a, table2 b where a.f1 = b.n1(+) and b.n1 is null; I learned this from Larry Elkins, I *think* I did it properly. Rather clever I thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Are people receiving postings
Hello, It's very interesting for me how will Madhavan receive answers if he can't see any posts. :-) Saturday, May 18, 2002, 4:33:20 AM, you wrote: LW Yep... Got it. LW Lon LW Madhavan Amruthur wrote: Hi, I just wanted to find out if people are receiving postings from oracle list. I can see my post come up but no posts from anybody else. Thanks --- Madhavan Amruthur Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).