RE: lock modes
Nope:) I can't for the life of me think why somebody would set this to none, as it could seriously damage your data integrity right? Sorry, I forgot to mention all of this in my original post.. Thanks Jared. Mark -Original Message- Sent: Friday, April 13, 2001 02:30 To: Multiple recipients of list ORACLE-L Mark, The parameter ROW_LOCKING defaults to 'ALWAYS', and is considered the normal behavior of Oracle. I've never heard of anyone explicitly setting this parameter. Do you know of some situation where that would be needed? Jared On Thursday 12 April 2001 12:47, Mark Leith wrote: In answer to the original question: Exclusive: means that the table in question is locked by a user exclusively. This is usually used as shown below by Ep, to stop other users *modifying* the data within the table (they can still select). Row Exclusive: You can specify an init parameter ROW_LOCKING, this will force a lock to be applied each time a row is updated. None: Means what it says on the tin:) There are no locks applied. HTH Mark -Original Message- Pierce Sent: Thursday, April 12, 2001 07:06 To: Multiple recipients of list ORACLE-L Partial answer only: See below for a code example (something I use to irritate users if run during normal data enty times!). It shows how how to lock a table for "mass update" while running in SQL*plus (amazing enough, it was probably originally found in an Oracle manual). Regards, Eric ---begin--- whenever sqlerror exit sql.code ; lock table STUDENT_MASTER in exclusive mode nowait ; whenever sqlerror continue ; ---end--- On 12 Apr 2001, at 9:26, Bunyamin K.Karadeniz wrote: Date sent:Thu, 12 Apr 2001 09:26:40 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Can anyone explain the lock modes written below.What do they mean . And how will I open the lock? Regards Exclusive Row Excl. None -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Jared Still 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: Mark Leith 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: Temporary Tablespace Design
Do not increase the sort_area_size at the database level but at the session level. When I have big batch jobs running alone at night I increased the hash_area_size and the sort_area_size of the session running the job. --- CC Harvest [EMAIL PROTECTED] a crit: Kirti: The server is solely used for the Oracle Database and it has 2GB Ram. I didn't increase sort_area_size too much because I thought the table is so big, and probablay I could not run them in the memory. That's why I just try the temp tablespace. Thanks, Chris --- "Deshpande, Kirti" [EMAIL PROTECTED] wrote: I would suggest that you increase (as much as possible) sort_area_size and sort_area_retained_size for your session when building indexes to minimize temporary tablespace use. Making temporary tablepspace of type temporary and adjusting default initial next extent size can also help. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: CC Harvest [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 11:23 AM To: Multiple recipients of list ORACLE-L Subject: Re:Temporary Tablespace Design Thanks Dick and Lisa for answering my question. I think I am going to either let the file auto-extend, or will try a smaller file as a start. I found my temp tablespace is too small(1GB) because it seems like takes forever to rebuild an index with nologging. I have 11 indexes on this tables, and it took me tons hours to do the index rebuilding. My application is a mixed system with 10% batch processing, and 90% OLAP. But we need the 10% batch processing part should be really fast. Thanks, Chris --- [EMAIL PROTECTED] wrote: Chris, First let me say that I have a TON of respect for Mike and count him as a friend. That said, I also take exception to many of his pronouncements from a practical, not theoretical, point of view. Given infinite resources, like disk space and memory and CPU, he does have it absolutely right. But in the real world there is infinite nothing. The first item on my list here it to look at what temp space is used for. It's mainly used for sorting, grouping, and distinct operations. These are the normal things that involve temp segments, and in a day to day operation that will consume an amount of space. The other item their used for is index building, which is not a normal day to day operation. Therefore the need for an extremely large temp tablespace is a sporadic and plan able event. Second, comes the question of the purpose of the database. If your building an OLTP system then temp usage is going to be even less since the majority of actions will affect few rows at one time. If it's a data warehouse on the other hand then data mining operations tend to make extreme use of temp for group and sort operations, but even so the amount of data being processed will not hit the extremes and when it does it's most likely bogus in the first place. My favorite in this vein is our CIO who let loose a Cartesian product query just because he forgot to join the fact table to the other tables. In this case the lack of temp space brought the query to a halt quickly and mercifully. OK, so where should you go? Well, I'll get into our DB's which range from our 150GB data warehouse to our 200GB operational data store. The former has 1GB of temp storage for normal operations. The latter gets along very well on 400MB of temp space. Both have a 14GB disk area that they share as required for those monster index rebuilds. Where you go from here is a lot of personal decision. I recommend starting small working your way up as necessary. The easiest way to do that is to enable auto-extend. Dick Goulet Reply Separator Author: CC Harvest [EMAIL PROTECTED] Date: 4/12/2001 12:05 AM What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management , it says "For Cost-based optimization, it should be 4 times of the largest table". I have a table of 60 Million records, and it costs 16GB, should I have a 64GB temp tablespace(I don't think so, though it's a 100GB database, and I have a 300GB of diskspace). Thanks for your advice. Chris __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ:
Constantly increasing process memory consumption
I would like to ask somebody who is experienced with PRO*C on Alpha OpenVMS. I have created process, which is connected to the database and constantly going. But his PGA is constantly increasing. On Metalink I have found advice to use kompile parameter (in file pcscfg.cfg) RELEASE_CURSOR=YES. Is there any other advice, experience or theoretical explanation? Thanks Michal Skursky -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Skursk=FD_Michal?= 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: Sseperate external procedure listeneers for 2 SIDS - Correcti
Thanks...but how to create 2 seperate external listeners, one for each SID? John -Original Message- From: Pampati, Kiran [SMTP:[EMAIL PROTECTED]] Sent: 12 April 2001 23:11 To: Multiple recipients of list ORACLE-L Subject: RE: Sseperate external procedure listeneers for 2 SIDS - Correcti Once you create two separate listeners for each SID, you can start and stop each listener separately from command line lsnrctl start/stop listener_name -Original Message- Sent: Thursday, April 12, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Correcti But for each SID I need an external proedure listener that I can start seperately from the standard listener. John -Original Message- From: Terry Ball [SMTP:[EMAIL PROTECTED]] Sent: 12 April 2001 19:21 To: Multiple recipients of list ORACLE-L Subject:Re: Sseperate external procedure listeneers for 2 SIDS - Correction We do that by creating a listener for each SID. So listener would look like: LISTENER_SID1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) STARTUP_WAIT_TIME_LISTENER_SID1 = 0 CONNECT_TIMEOUT_LISTENER_SID1 = 0 TRACE_LEVEL_LISTENER_SID1 = OFF SID_LIST_LISTENER_SID1 = (SID_LIST = (SID_DESC = (SID_NAME = SID1) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) LISTENER_SID2 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1526) ) ) STARTUP_WAIT_TIME_LISTENER_SID2 = 0 CONNECT_TIMEOUT_LISTENER_SID2 = 0 TRACE_LEVEL_LISTENER_SID2 = OFF SID_LIST_LISTENER_SID2 = (SID_LIST = (SID_DESC = (SID_NAME = SID2) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) And tnsnames.ora would have entries for both SIDs with the corresponding port. Terry John Dunn wrote: Correction I have 2 SIDS running on my machine. I want to have a seperate external procedure listener for each SID. Can someone tell me what my listener.ora amd tnsnames.ora files should look like? Oracle is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Terry Ball 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: John Dunn 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: Pampati, Kiran 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
RE: How to get rid off file permanently?
Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion? [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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 Sawmiller 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 get rid off file permanently?
You shouldn't joke like that :). There are some real new newbies on this list who will follow exactly what you say. Gene [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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: Gene Sais 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).
Pro*c Host array.
Hi, I want to use dynamic host array's in pro*c i.e. assigning array size in runtime by using variabl to reduse memory allocation. I am useing pro*c 1.6 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abhijit Bhivapure 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:32bit v. 64bit Oracle
Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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: Sseperate external procedure listeneers for 2 SIDS - Correcti
2 listeners cannot listen on the same port. Alex Hillman -Original Message- Sent: Friday, April 13, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Correcti mysid_lis = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= mysid) ) (ADDRESS= (PROTOCOL= TCP) (Host= myhost.mynet.com) (Port= 1525) ) ) STARTUP_WAIT_TIME_mysid_Lis = 0 CONNECT_TIMEOUT_mysid_Lis = 10 TRACE_LEVEL_mysid_Lis = OFF SID_LIST_mysid_Lis = (SID_LIST = (SID_DESC = (SID_NAME = mysid) (ORACLE_HOME = /opt/oracle/product/8.1.6) (GLOBAL_DBNAME= myhost.mynet.com.) ) ) yoursid_lis = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= yoursid) ) (ADDRESS= (PROTOCOL= TCP) (Host= myhost.mynet.com) (Port= 1525) ) ) STARTUP_WAIT_TIME_mysid_Lis = 0 CONNECT_TIMEOUT_mysid_Lis = 10 TRACE_LEVEL_mysid_Lis = OFF SID_LIST_mysid_Lis = (SID_LIST = (SID_DESC = (SID_NAME = yoursid) (ORACLE_HOME = /opt/oracle/product/8.1.6) (GLOBAL_DBNAME= mysid.mynet.com.) ) ) Kevin Toepke - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. - The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. - -Original Message- Sent: Friday, April 13, 2001 7:10 AM To: Multiple recipients of list ORACLE-L Correcti Thanks...but how to create 2 seperate external listeners, one for each SID? John -Original Message- From:Pampati, Kiran [SMTP:[EMAIL PROTECTED]] Sent:12 April 2001 23:11 To: Multiple recipients of list ORACLE-L Subject: RE: Sseperate external procedure listeneers for 2 SIDS - Correcti Once you create two separate listeners for each SID, you can start and stop each listener separately from command line lsnrctl start/stop listener_name -Original Message- Sent: Thursday, April 12, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Correcti But for each SID I need an external proedure listener that I can start seperately from the standard listener. John -Original Message- From: Terry Ball [SMTP:[EMAIL PROTECTED]] Sent: 12 April 2001 19:21 To:Multiple recipients of list ORACLE-L Subject:Re: Sseperate external procedure listeneers for 2 SIDS - Correction We do that by creating a listener for each SID. So listener would look like: LISTENER_SID1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) STARTUP_WAIT_TIME_LISTENER_SID1 = 0 CONNECT_TIMEOUT_LISTENER_SID1 = 0 TRACE_LEVEL_LISTENER_SID1 = OFF SID_LIST_LISTENER_SID1 = (SID_LIST = (SID_DESC = (SID_NAME = SID1) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) LISTENER_SID2 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1526) ) ) STARTUP_WAIT_TIME_LISTENER_SID2 = 0 CONNECT_TIMEOUT_LISTENER_SID2 = 0 TRACE_LEVEL_LISTENER_SID2 = OFF SID_LIST_LISTENER_SID2 = (SID_LIST = (SID_DESC = (SID_NAME = SID2) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) And tnsnames.ora would have entries for both SIDs with the corresponding port. Terry John Dunn wrote: Correction I have 2 SIDS running on my machine. I want to have a seperate external procedure listener for each SID. Can someone tell me what my listener.ora amd tnsnames.ora files should look like? Oracle is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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,
Fwd: Materialised view
I've sent that mail days ago with no feedback, Oracle Support hasn't been able help, anybody ? On Oracle 816/Solaris 5.7, I'm trying to refresh fast a mview without success: ORA-12032. It's a mview with single table aggregate, I've followed all the restrictions in the doc (I'm having a mview log, count is present,... ) I can refresh force but it's doing a complete not a fast refresh. Why ? = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.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:RE: lock modes
Mark, I had OTS recommend setting this back on version 6.0.36 due to a bug. But since I've removed it. Dick Goulet Reply Separator Author: "Mark Leith" [EMAIL PROTECTED] Date: 4/12/2001 11:55 PM Nope:) I can't for the life of me think why somebody would set this to none, as it could seriously damage your data integrity right? Sorry, I forgot to mention all of this in my original post.. Thanks Jared. Mark -Original Message- Sent: Friday, April 13, 2001 02:30 To: Multiple recipients of list ORACLE-L Mark, The parameter ROW_LOCKING defaults to 'ALWAYS', and is considered the normal behavior of Oracle. I've never heard of anyone explicitly setting this parameter. Do you know of some situation where that would be needed? Jared On Thursday 12 April 2001 12:47, Mark Leith wrote: In answer to the original question: Exclusive: means that the table in question is locked by a user exclusively. This is usually used as shown below by Ep, to stop other users *modifying* the data within the table (they can still select). Row Exclusive: You can specify an init parameter ROW_LOCKING, this will force a lock to be applied each time a row is updated. None: Means what it says on the tin:) There are no locks applied. HTH Mark -Original Message- Pierce Sent: Thursday, April 12, 2001 07:06 To: Multiple recipients of list ORACLE-L Partial answer only: See below for a code example (something I use to irritate users if run during normal data enty times!). It shows how how to lock a table for "mass update" while running in SQL*plus (amazing enough, it was probably originally found in an Oracle manual). Regards, Eric ---begin--- whenever sqlerror exit sql.code ; lock table STUDENT_MASTER in exclusive mode nowait ; whenever sqlerror continue ; ---end--- On 12 Apr 2001, at 9:26, Bunyamin K.Karadeniz wrote: Date sent:Thu, 12 Apr 2001 09:26:40 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Can anyone explain the lock modes written below.What do they mean . And how will I open the lock? Regards Exclusive Row Excl. None -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Jared Still 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: Mark Leith 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).
Dropping partitions with data versus empty
Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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: [Basic logon architecture for multiple apps in a db]
HI dba man, I made my own security system by making database users and giving them synonyms to access the owners objects,also I created public synonyms for the objects .Then I created roles and assigned them to menu items in the main menu and sub-menus.After creating the user (in a form I developed myself,)I made another form to give certain functions(forms) to different users,and in this form I grant the roles accordingly. If this solution seems ok with you,let me know,I 'll give you more tips and tricks. By the way,the system is secured and the customer is satisfied. Oracle dba Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER 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).
redo for 64Kper file bitmap for locally managed tablespaces
Anybody knows how Oracle insure recoverability of such bitmaps. My understanding is that any change should be written into redo log file. Question is how much info is written etc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Dropping partitions with data versus empty
Removing data from a partition is not a lot of work : alter table X truncate partition Y ; --- [EMAIL PROTECTED] a crit: Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.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: Sseperate external procedure listeneers for 2 SIDS - Correcti
But, it can be modified. It was sent as a format, not as the final word. Terry "Libal, Ivo" wrote: But it is normal listener - not external procedure listener. There can be a problem with tnsnames.ora entry for EXTPROC_CONNECTION_DATA. regards Ivo Libal -Original Message- Sent: Friday, April 13, 2001 03:41 PM To: Multiple recipients of list ORACLE-L Correcti The listener.ora I sent is two seperate listeners. Just substitute the SID names for SID1 and SID2 and issue the start command. lsnrctl start listener_sid1 lsnrctl start listener_sid2 Terry John Dunn wrote: Thanks...but how to create 2 seperate external listeners, one for each SID? John -Original Message- From: Pampati, Kiran [SMTP:[EMAIL PROTECTED]] Sent: 12 April 2001 23:11 To: Multiple recipients of list ORACLE-L Subject: RE: Sseperate external procedure listeneers for 2 SIDS - Correcti Once you create two separate listeners for each SID, you can start and stop each listener separately from command line lsnrctl start/stop listener_name -Original Message- Sent: Thursday, April 12, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Correcti But for each SID I need an external proedure listener that I can start seperately from the standard listener. John -Original Message- From: Terry Ball [SMTP:[EMAIL PROTECTED]] Sent: 12 April 2001 19:21 To: Multiple recipients of list ORACLE-L Subject:Re: Sseperate external procedure listeneers for 2 SIDS - Correction We do that by creating a listener for each SID. So listener would look like: LISTENER_SID1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1521) ) ) STARTUP_WAIT_TIME_LISTENER_SID1 = 0 CONNECT_TIMEOUT_LISTENER_SID1 = 0 TRACE_LEVEL_LISTENER_SID1 = OFF SID_LIST_LISTENER_SID1 = (SID_LIST = (SID_DESC = (SID_NAME = SID1) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) LISTENER_SID2 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = hostname) (Port = 1526) ) ) STARTUP_WAIT_TIME_LISTENER_SID2 = 0 CONNECT_TIMEOUT_LISTENER_SID2 = 0 TRACE_LEVEL_LISTENER_SID2 = OFF SID_LIST_LISTENER_SID2 = (SID_LIST = (SID_DESC = (SID_NAME = SID2) (ORACLE_HOME = /opt/app/oracle/product/8.0.6) (PRESPAWN_MAX = 10) ) ) And tnsnames.ora would have entries for both SIDs with the corresponding port. Terry John Dunn wrote: Correction I have 2 SIDS running on my machine. I want to have a seperate external procedure listener for each SID. Can someone tell me what my listener.ora amd tnsnames.ora files should look like? Oracle is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Terry Ball 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: John Dunn 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
Stephen Andert's article
Stephen Andert, a member of this list, has a SQL*Loader-related article running on the O'Reilly Associates web site. You can get to it from the O'Reilly home page (halfway down right-hand column), or you can get to it directly at the following URL: http://oracle.oreilly.com/news/oraclesqlload_0401.html. Disclaimer: the article is related to one of my books. That having been said, I found Stephen's article to be very interesting, and I'd like to see him get some visibility from it. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Dropping partitions with data versus empty
On Fri, 13 Apr 2001, Feng, Jun wrote: We have that kind application running on the production and didn't have any problem since it was deployed last Oct.. The application will truncate the one of the table partitions which contains 99% of the data (about 7M records) before reload the data every two weeks. For you situation, you can truncate partition then drop it. It is easy, clean and quick. Don't forget to recreate/rebuild the indexes - when you truncate or drop a partition, it places the indexes into an unusable state. FWIW, I haven't had any problems dropping full partitions - it's quicker than a truncate/drop (since the same number of extents need to be deallocated, letting drop clean up the extents is quicker than typing in 'alter table truncate partition foo;', 'alter table drop partition foo'). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: Basic logon architecture for multiple apps in a db
Denny, Thanks for the tip, I'll give it a try. It sounds like it will work. Of course, there's a list on Metalink of places where it doesn't work or where it causes errors. But it sounds just right - thanks. Yosi -Original Message- Sent: Thursday, April 12, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Hi Yosi, You may want to check alter session set current_schema=application schemaname This gives you the best of both worlds. You can let the users login using their own logins and still access the objects in the application schema without using synonyms. Regards, Denny [EMAIL PROTECTED] wrote: Ron, When they log in directly, do they access the tables by fully qualifying the owner, or do they use synonyms? Yosi -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: Basic logon architecture for multiple apps in a db Yosi The users at our location do both methods of logons. Some access the database directly with "create session" privileges and have a role granted to them that can access the data. Other applications have the user login from the application access the database and the table privileges are granted to the application id. The user assessing the database was inplace before I started working here. I control the tables the users have assess to by using roles on all of the new applications if the developer does not code it to have an application id hitting the database. Both methods work well and I am still able to "see" the originating user's machine name that they logged onto the client with. That helps in tracking down who is accessing the servers. ROR mm [EMAIL PROTECTED] 04/11/01 04:40PM O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Denny Koovakattu http://www.oneco.net/ _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu 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
RE: Dropping partitions with data versus empty
Jun, Thanks for your reply. We are considering truncating the partitions first. Our main issue is recoverability. Not so much if we can't recover a partition that we want to get rid of but rather if we accidentally truncate a partition that we want to keep. Just trying to cover all our bases. Probably we will use the truncate command first. We'll just have to have someone proofread the script first. Cherie "Feng, Jun" jfeng@netsolTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: RE: Dropping partitions with data versus empty root@fatcity. com 04/13/01 11:00 AM Please respond to ORACLE-L We have that kind application running on the production and didn't have any problem since it was deployed last Oct.. The application will truncate the one of the table partitions which contains 99% of the data (about 7M records) before reload the data every two weeks. For you situation, you can truncate partition then drop it. It is easy, clean and quick. Jun -Original Message- Sent: Friday, April 13, 2001 10:12 AM To: Multiple recipients of list ORACLE-L Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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: Feng, Jun 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: Dropping partitions with data versus empty
Stephane, Thanks for your reply. We are considering truncating the partitions first. Our main issue is recoverability. Not so much if we can't recover a partition that we want to get rid of but rather if we accidentally truncate a partition that we want to keep. Just trying to cover all our bases. Probably we will use the truncate command first. We'll just have to have someone proofread the script first. Cherie paquette stephane stephane_paquette@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: Re: Dropping partitions with data versus empty [EMAIL PROTECTED] 04/13/01 10:45 AM Please respond to ORACLE-L Removing data from a partition is not a lot of work : alter table X truncate partition Y ; --- [EMAIL PROTECTED] a crit: Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.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). -- 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: Dropping partitions with data versus empty
Cherie, And how 'truncate a partition' will help you with recoverability? Truncating partition is still DDL - not DML. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 1:20 PM Jun, Thanks for your reply. We are considering truncating the partitions first. Our main issue is recoverability. Not so much if we can't recover a partition that we want to get rid of but rather if we accidentally truncate a partition that we want to keep. Just trying to cover all our bases. Probably we will use the truncate command first. We'll just have to have someone proofread the script first. Cherie "Feng, Jun" jfeng@netsolTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: RE: Dropping partitions with data versus empty root@fatcity. com 04/13/01 11:00 AM Please respond to ORACLE-L We have that kind application running on the production and didn't have any problem since it was deployed last Oct.. The application will truncate the one of the table partitions which contains 99% of the data (about 7M records) before reload the data every two weeks. For you situation, you can truncate partition then drop it. It is easy, clean and quick. Jun -Original Message- Sent: Friday, April 13, 2001 10:12 AM To: Multiple recipients of list ORACLE-L Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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: Feng, Jun 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: Igor Neyman 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).
Unix Admin - Looking for HP-Glanceplus doc
Greetings all, We have a DB running on HP-UX11. I am not the unix admin but I can run Glance on the OS but clueless on the metrics being displayed. I am hoping someone who has access to any documentation on the HP Glanceplus utility can shar that with me. The "man" provides limited description. Appreciate any feedback on this HP utility. Many thanks, Ed __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Stephen Andert's article
On Fri, 13 Apr 2001, Jonathan Gennick wrote: Stephen Andert, a member of this list, has a SQL*Loader-related article running on the O'Reilly Associates web site. You can get to it from the O'Reilly home page (halfway down right-hand column), or you can get to it directly at the following URL: http://oracle.oreilly.com/news/oraclesqlload_0401.html. Very nice review - great representation of efficiency in increasing BIND and ROWS parameters. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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 get rid off file permanently?
If someone has been given access to root and doesn't know what they are doing, then the sysadmins deserve whatever happens to their systems... My two cents -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais Sent: Friday, April 13, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to get rid off file permanently? You shouldn't joke like that :). There are some real new newbies on this list who will follow exactly what you say. Gene [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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: Gene Sais 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
Re: PL/SQL wrappers
I can't comment on the cross-platform dependencies, but I've deployed wrapped stuff with no problems in the past...Of course, don't lose your source! hth connor --- John Dunn [EMAIL PROTECTED] wrote: We are considering using wrappers to hide our PL/SQL code from customers. Are there any issues to be aware of?..we need to implement on various Unix platforms. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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).
migrating to 11i
I am in the initial test phase of migrating our Oracle 8.0.5.2.1 database and Oracle Applications 11.0.2 to Oracle 8.1.6 and Applications 11.5.3. We run this on Sun Sparc Solaris 2.6 In reading the Upgrading Oracle Applications Release 11.5.3 documention, I read on page 1-14 that Applications 11i requires an blocksize of 8k or larger and if the current environment is 2k or 4k you must migrate the database to a blocksize of 8k or larger. We currently have a 2k blocksize. Has anyone faced this issue before? Can you give me a overview of your solution path? I know I can re-create the database using imp/exp and setting the blocksize to 8k but is there another method? The documentation said "must migrate the database to a blocksize of 8k or larger". can this be done during the migration process? Assistance is greatly appreciated.. thanks in advance. roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: Stephen Andert's article
Thanks for all the feedback. Hope everyone that uses SQL*Loader benefits from it. Stephen [EMAIL PROTECTED] 04/13 10:31 AM On Fri, 13 Apr 2001, Jonathan Gennick wrote: Stephen Andert, a member of this list, has a SQL*Loader-related article running on the O'Reilly Associates web site. You can get to it from the O'Reilly home page (halfway down right-hand column), or you can get to it directly at the following URL: http://oracle.oreilly.com/news/oraclesqlload_0401.html. Very nice review - great representation of efficiency in increasing BIND and ROWS parameters. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: Stephen Andert 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: Stephen Andert's article
Ed: Thanks for your compliments. I'm glad you enjoyed it. It was a fun article to write because I had experienced such great results after spending very little time tuning the jobs. Tuning is always trying to find the easiest way to get the best results and this was a a great example the a bast-case scenario. I like to read a lot and when I read technical books, I always have a pen, highlighter and post-its. You can tell how much I got out of a book by how may post-it's are sticking out of it. Stephen Andert [EMAIL PROTECTED] 04/13 11:06 AM Jonathan, Congratulations on finishing the book. After reading Stephen's article, I can't wait to pick up a copy!! Stephen, Great job in reviewing the book! It was great to learn how you were able to apply the knowledge acquired from the book into real-life experiences. It's amazing how many people read a book and never utilize what they've learned from it!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 13, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Stephen Andert, a member of this list, has a SQL*Loader-related article running on the O'Reilly Associates web site. You can get to it from the O'Reilly home page (halfway down right-hand column), or you can get to it directly at the following URL: http://oracle.oreilly.com/news/oraclesqlload_0401.html. Disclaimer: the article is related to one of my books. That having been said, I found Stephen's article to be very interesting, and I'd like to see him get some visibility from it. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Haskins, Ed 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: Stephen Andert 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 get rid off file permanently?
Not every company is big enough to have an IT staff. Some I've worked at, you are the developer, sysadmin, network/firewall admin, and dba. However, I would draw the line on doing bathrooms :-) [EMAIL PROTECTED] 04/13/01 01:46PM If someone has been given access to root and doesn't know what they are doing, then the sysadmins deserve whatever happens to their systems... My two cents -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais Sent: Friday, April 13, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to get rid off file permanently? You shouldn't joke like that :). There are some real new newbies on this list who will follow exactly what you say. Gene [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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: Gene Sais INET: [EMAIL
RE: How to get rid off file permanently?
Plus, they can practice recover (or determine if their backup procedures are adequate). -Original Message- Sent: Friday, April 13, 2001 10:46 AM To: Multiple recipients of list ORACLE-L If someone has been given access to root and doesn't know what they are doing, then the sysadmins deserve whatever happens to their systems... My two cents -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais Sent: Friday, April 13, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to get rid off file permanently? You shouldn't joke like that :). There are some real new newbies on this list who will follow exactly what you say. Gene [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
Re: Stephen Andert's article
Jonathan, Nice review. Looks like a fantastic book! It would have been great to have it when I first started Oracle (or will be great to get it if we start having more complex data loading requirements than is currently the case, e.g. graphics files). About 5 or 6 years ago I called Oracle tech support asking why the SQL*Loader documentation (Oracle67) wasn't very good, and if any supplemental information was available. A particulary good Oracle tech support guy (Dan Needles?) faxed me about 25 pages of "internal" Oracle documents (notes/etc.) about SQL*Loader, some of which he had authored. My guess is that most/all of that material he covered is also in your book, plus more. OT: I was interested in the waterfall stuff in your ".sig" file, so I clicked. If you don't mind the suggestion, you might consider clearly labeling the waterfall map image (http://MichiganWaterfalls.com/up_map.gif) as being upper Michigan. Being from the west coast and not very familiar with midwestern geography, it wasn't apparent at first glance what the map image was, and I had to refer to a map of the whole state (at www.mapquest.com) to get a clear idea of the specifics. regards best wishes, ep On 13 Apr 2001, at 8:30, Jonathan Gennick wrote: Date sent: Fri, 13 Apr 2001 08:30:22 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Stephen Andert, a member of this list, has a SQL*Loader-related article ... http://oracle.oreilly.com/news/oraclesqlload_0401.html. ... http://MichiganWaterfalls.com ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Performance Degradation/anomaly?
On 13 Apr 2001, at 10:06, Ed wrote: the re-start seems to clear the buffer or any "cow webs" from previous session. As all old timer Oracle users know, you really want to get rid of all those buffer clogging "cow webs" ASAP, otherwise you might get "mad dot com" disease. :) Go on down to your local feed store and get a couple of those 100 lb bags of bran, should do the trick. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
How does dropping a partition affect the rest of the table?
I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping a date-range partition affect the rest of the table/partitions? I read that if I drop a partition with a global partitioned index that the entire global index will need to be rebuilt but that's about all I've seen about the affect on the other partitions. Can I drop an unneeded partition on the fly? What is the effect on performance of the rest of the table? Does anything need to be brought offline before I drop the desired partition? Thanks in advance to all you knowledgable partitioners. Cherie Machler Gelco Information Network -- 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: Unix Admin - Looking for HP-Glanceplus doc
Hi Ed, If possible run Glance in motif mode (gpm under X-Windows). It has better on-line Help available. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Ed [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: Unix Admin - Looking for HP-Glanceplus doc Greetings all, We have a DB running on HP-UX11. I am not the unix admin but I can run Glance on the OS but clueless on the metrics being displayed. I am hoping someone who has access to any documentation on the HP Glanceplus utility can shar that with me. The "man" provides limited description. Appreciate any feedback on this HP utility. Many thanks, Ed __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Deshpande, Kirti 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:32bit v. 64bit Oracle
Hi! can u pls tell me the errros u encountered in opening 64-bit database using 32-bit Oracle or vice versa? Thanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Fri, 13 Apr 2001 06:05:25 -0800 Subject:Re:32bit v. 64bit Oracle Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Unix Admin - Looking for HP-Glanceplus doc
Hi Kirti, Unfortunately I am running this in char-mode. However, I did managed to download a few pdf docs from the HP site(the docs did mentioned gpm). Anyway, thanks very much for your feedback. Best regards, Ed --- "Deshpande, Kirti" [EMAIL PROTECTED] wrote: Hi Ed, If possible run Glance in motif mode (gpm under X-Windows). It has better on-line Help available. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Ed [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject:Unix Admin - Looking for HP-Glanceplus doc Greetings all, We have a DB running on HP-UX11. I am not the unix admin but I can run Glance on the OS but clueless on the metrics being displayed. I am hoping someone who has access to any documentation on the HP Glanceplus utility can shar that with me. The "man" provides limited description. Appreciate any feedback on this HP utility. Many thanks, Ed __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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 get rid off file permanently?
Well, if a total newbie is given root access to production machines then my suggestion will actually help them streamline their operating procedures and find flaws in their administration principles. Actually, you might say that if there is a company which has a person of the right mindset to follow my advice and if that person has root access to production machines, my advice will probably help them straighten out their biggest mistake - being in the business in the first place. As a DBA and a gentleman I can not but take pride in helping people to stop making mistakes. -Original Message- Sent: Friday, April 13, 2001 8:21 AM To: Multiple recipients of list ORACLE-L Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion? [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Gogala, Mladen 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 Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: Performance Degradation/anomaly?
Ed, try looking in the v$session_wait to see what is the session waiting for. That should give you a hint on what might be going on. If you cannot find anything in the database, check OS, swapping, paging, CPU, queues on the disk drives etc -Original Message- Sent: Friday, April 13, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Greetings all, This is more of a tuning question. We have a pl/sql procedure doing inserts and updates to a very large table. This procedure process different groups of same types of data sequentially. The difference between these groups is with the volume of raw data. When the procedure gets to process a large dataset (large volume), the performance slows significantly. However, it will speed up when it gets to process a smaller dataset. The clincher: If I was to terminate and re-start the procedure the performance picks up for the same large dataset. It behave as though the buffer is "full" and the re-start seems to clear the buffer or any "cow webs" from previous session. The procedure has been tuned. The target table has recently been defragmented. No other processes running concurrently. We suspect the database needs tuning but do not know how to proceed. What should we be looking for? I am hoping to get suggestions on what to do to tune the DB. Appreciate any feedback. Thanks very much, Ed __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Gogala, Mladen 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 get rid off file permanently?
delicious. :) On 13 Apr 2001, at 13:40, Gogala, Mladen scribbled with alacrity and cogency: ... As a DBA and a gentleman I can not but take pride in helping people to stop making mistakes. next: ... John Leo on CSPAN. As you may recall, he is the columnist from "U.S. News and World Report" who gave CSUS President Gerth the 1999 "Sheldon Award" for political correctness. ( http://www.usnews.com/usnews/issue/000103/03john.htm ). ---excerpt--- ... The coveted annual prize that goes to a wimpy college president Exhausted staffers for this column have finished wading through dozens of nominees for the third annual Sheldon Award. Named for Sheldon Hackney, who scaled the heights of Sheldonism as president of the University of Pennsylvania, this coveted prize is given each year to a craven college president who looks the other way while campus newspapers are stolen. ... ---end--- ... on CSPAN, John Leo (warm, mild, grandfatherly, caring, thoughtful, principled [witty]) was talking about the topics in his new book "Incorrect Thoughts" at an event organized by the Independent Women's Forum. Since IWF's (very interesting) web site hasn't been updated recently, I found some other links about Leo's book that you might also find interesting. http://www.iwf.org - John Leo's columns: http://www.jewishworldreview.com/cols/leo1.asp - (and: http://www.usnews.com/usnews/opinion/jleo.htm ) http://www.jewishworldreview.com/cols/leo031201.asp excerpt from the above link: ... That notion that free speech is a tool of the oppressor is now mainstream in the campus culture. This is why campus newspapers with the wrong news keep getting stolen, posters for the wrong events keep getting torn down, and speakers with the wrong views keep getting disinvited or silenced. Recent nonspeakers at Berkeley, home of the free-speech movement, include conservative organizer Daniel Flynn (shouted down) and former Israeli Prime Minister Binyamin Netanyahu (threats of violence, advised to withdraw by police). Berkeley gets another chance to oppose free speech this week. David Horowitz is scheduled to speak there on March 15 (end excerpt) http://www.usnews.com/usnews/issue/000612/12john.htm excerpt from the above link: ... Post-1960s liberalism has lost its communal sensibility and now talks almost exclusively of autonomy and rights, not obligation or moral accountability. As Stein [_How I Accidentally Joined the Vast Right-Wing Conspiracy: (And Found Inner Peace)_] points out, it has aggressively labored to devalue society by trying to banish moral and religious discourse from the public arena. Values are viewed as matters of personal taste. Even the famous liberal belief in openness, tolerance, and free speech now looks like a discarded tenet. Witness all the disinvited speakers, stolen newspapers, and current not-very-liberal efforts to silence Laura Schlessinger and derecognize campus Christian groups. What passes for liberalism now, Stein says, is often an attempt to impose rectitude, "usually with the active cooperation of the news media, government agencies, and Hollywood, all of which somehow get to call their own agenda 'inclusive' instead of 'narrow.' " (end excerpt) more at: http://www.google.com/search?q=john+leo+incorrect+thoughts --- also: http://www.gseis.ucla.edu/courses/ed191/assignment1/1970illich.html excerpt: ... According to Illich, "obligatory instruction assumes the belief that man can do what God cannot, namely, manipulate others for their own salvation" (1970, p.50). By deschooling society, schools would continue to exist but their workings would be very different from those operating at present. Deschooling could only occur given alternative social arrangements and legal protections as well as a reconceptualization of what constitutes learning in the heart of every deschooled person. According to Illich, schools are the "reproductive organ of a consumer society" (1970). Schools produce myths upon which an economic society depends. Schooling is a ritual performed by participants who are made blind to the discrepancy between the purpose for and the consequences of the ritual. Despite the advertised purpose of promoting social equality and democratic participation, schooling is "the ritual of a society committed to progress and development" (Cayley, 1992, p. 67). In his thesis titled, Deschooling Society, Ivan Illich promulgates four myths created by the school ritual; 1) the myth of unending consumption, 2) the myth of measurement of values, 3) the myth of packaging values, and 4) the myth of self-perpetuating progress. ... ...As the creator, propagator, and protector of these four educational myths, schools retain their sacred positions as the purveyor of "secular
RMAN
I am trying to setup rman.The catalog database(cat) and target database(tar) are running on Oracle 8.1.5. I am following the Note from Metalink No.106432.1 and 109223.1.I am following all the steps as given in the note but I am facing errors. When REgistering the Target database I did the following steps $ORACLE_SID=tar $rman TARGET system/manager / RCVCAT rman/rman@cat Recovery Manager: Release 8.1.6.0.0 - Production RMAN-06193: connected to target database (not started) RMAN-06008: connected to recovery catalog database The Target database has been started and open for use. $sqlplus system/manager@tar will connect me to the target database. I checked some docs on metalink which tells that the target database should started(which is TRUE in mycase). The other doc says that the password file must be create and the init.ora file should have REMOTE_LOGIN_PASSWORD=exclusive(which is also TRUE in my case for both the database). $TNSPING tar TNS Ping Utility for Solaris: Version 8.1.6.0.0 - Production on 13-APR-2001 14:03:55 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=venus)(PORT=1521)) OK (10 msec) Can anyone tell me how to complete the set up successfully.Why am i getting RMAN-06193: connected to target database (not started) error. Pls advice Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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).
Sr. Oracle Financials DBAs Needed in Houston..
Major Houston company needs several Sr. Level Oracle Financials DBAs to join its' I.T. staff. These DBAs will work on the support side. They will support developers and end-users. DBA will support both internal and external clients. Client has gone from 107. To 11. Requirements: -Must have 4 yrs Oracle Financials DBA experience. -Must be able to handle financial patches. -Looking for someone whose last install was within the past 6 months. -Looking for team players, not lone solo personalities. -U.S. citizenship or permanent residency. This company offers: -Salary for Sr. DBA's up to 105K with full benefits and 401K. -Also stock options may be included in the comp package for highly talented candidates. -Company will pay relo or partial relo.. NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Fin DBA/Houston/Sanders Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for you. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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 does dropping a partition affect the rest of the table?
On Fri, 13 Apr 2001, [EMAIL PROTECTED] wrote: I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping a date-range partition affect the rest of the table/partitions? New data will be inserted into the next-highest partition. Current data in the partition will be lost. Can I drop an unneeded partition on the fly? What is the effect on performance of the rest of the table? Does anything need to be brought offline before I drop the desired partition? The hit will be in rebuilding the indexes. Unless you have a large number of extents in the partition, it will drop very quickly - quick enough not to be noticeable unless a user is running a query or transaction against the data in the partition (the query/transaction will fail). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: Database Cache of Oracle9ias
Hi Kevin, The Database Cache Assistant works fine till it reaches the last part where it tries to export some User data.. The error which it gives is "Unable to export User privileges" and then it fails and moves onto installing other components, I tried to install Oracle DB 8.1.7 and Oracle 9iAS on the same server. The configuration reaches the last part of the Database Cache configuration screen. Moreover once I sucessfully installed Oracle 8.1.6 DB and Oracle 8iAS (Earlier version) on the same server.. Thanks.. Sushant --- Kevin Tsay [EMAIL PROTECTED] wrote: What's the problems you have ? --Kevin -Original Message- Sent: Thursday, April 12, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Hi all, Has anybody installed Oracle Database Cache of Oracle 9iAS sucessfully.. Thanks in advance... Sushant --- TARUN SHARMA [EMAIL PROTECTED] wrote: Hi, Yes u can install oracle 8i DB and 9iAS on the same machine. On Wed, 11 Apr 2001, Seema Singh wrote: Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: TARUN 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle 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: Kevin Tsay 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle 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).
stupid DBA
Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs. Stupid job mkt. Stupid software Engineer! I am considering to change to be a nurse associate or something like that. Best wishes! Yours sincerely, Robert Chen ___ Cisco Certified Network Associate Oracle Certified Professional DBA SUN Certified Java Programmer SUN Certified Solaris7 System Administrator SUN Certified Solaris7 Network Administrator - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 3:20 PM Hi Kevin, The Database Cache Assistant works fine till it reaches the last part where it tries to export some User data.. The error which it gives is "Unable to export User privileges" and then it fails and moves onto installing other components, I tried to install Oracle DB 8.1.7 and Oracle 9iAS on the same server. The configuration reaches the last part of the Database Cache configuration screen. Moreover once I sucessfully installed Oracle 8.1.6 DB and Oracle 8iAS (Earlier version) on the same server.. Thanks.. Sushant --- Kevin Tsay [EMAIL PROTECTED] wrote: What's the problems you have ? --Kevin -Original Message- Sent: Thursday, April 12, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Hi all, Has anybody installed Oracle Database Cache of Oracle 9iAS sucessfully.. Thanks in advance... Sushant --- TARUN SHARMA [EMAIL PROTECTED] wrote: Hi, Yes u can install oracle 8i DB and 9iAS on the same machine. On Wed, 11 Apr 2001, Seema Singh wrote: Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: TARUN 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle 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: Kevin Tsay 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!? Get email at your own
RE: 9iAS -- Boxes on which to run
Jared, Even though it was easier to support (which can add up to cost savings) was the performance a problem for you where on the Intel boxes? Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 7:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: 9iAS -- Boxes on which to run Sorry to hear this Larry. At BlueCross we moved the server off of Intel ( Dual 500 MHZ, NT 4.0 ) because it was *so* much easier to support on Solaris. This sounds like a backwards move that probably cost more in the long run due to maintenance and downtime. 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: stupid DBA
On Fri, 13 Apr 2001, Robert Chen wrote: Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs. Stupid job mkt. Stupid software Engineer! I am considering to change to be a nurse associate or something like that. Tomorrow you may want to get up on the other side of the bed :) although, as best noted in ASR, all hardware sucks, all software sucks. It's just different degrees of suckage. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: stupid DBA
Ever considered trying out for fighter pilot in the chinese air force? I think they have an opening. On 13 Apr 2001, at 14:45, Robert Chen wrote: Date sent: Fri, 13 Apr 2001 14:45:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ...I am considering to change to be a nurse associate or something like that. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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 does dropping a partition affect the rest of the table?
On Fri, 13 Apr 2001, Gregory Conron wrote: unless a user is running a query or transaction against the data in the partition (the query/transaction will fail). d'oh! must correct myself - if a user is running a transaction against the data, the alter table drop will fail as it will not be able to obtain an exclusive lock. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: 9iAS -- Boxes on which to run
Eric, Thanks for the feedback, and yes, the Intel boxes would be running NT. The DB will still be on the HP V2500. And where did you get the info on 8.1.7 and Forms Server not being able to be on the same NT / W2K machine? I am about to try to install 9iAS on my W2K box at home. I already have 8.1.7 EE, Forms 4.5/5.0/6i, and tons of other stuff installed. I've read through the install guide, the various release notes, etc and never came across that. But, if it is so, I don't intend to waste a perfectly good day trying to get things to work. Regards, Larry G. Elkins [EMAIL PROTECTED] Larry, Just in case you didn't know, and it might be pertinent, any NT (Win/2000) database from 8.1.7 on supposedly can't run on the same machine as the Forms web server. (I just realized that you didn't actually say you are planning on running on NT.) -- 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: 9iAS -- Boxes on which to run
On 13 Apr 2001, at 17:12, [EMAIL PROTECTED] wrote: To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Date sent: Fri, 13 Apr 2001 17:12:54 -0500 And where did you get the info on 8.1.7 and Forms Server not being able to be on the same NT / W2K machine? Oracle tech support. They were clear (my recollection of verbal phone conversion) that as of 8.1.7, "middle tier" stuff would not run on the same NT server box as the database. They said that I needed to read the (latest?) "middle tier" white papers to understand the new (as of 8.1.7) "middle tier web architectural" issues, which they said are "complex". :) Unfortunately I haven't had time yet. This was in the context of a conversation about a new Win2k server that we are setting Oracle8 up on, and I wanted to know if it was still going to be possible to run the next equivalent to WebDB on the same box as the database. I then siad that it sounded like I was going to have to convert our old Netware3 server to NT (Win/2000) in order to test the 8.1.7 and later "middle tier" web stuff. They said that was correct. so, it was specific answer, not just some general info. Since the documentation you have apparently doesn't cover the issue, you probably ought to call Oracle tech support. I am about to try to install 9iAS on my W2K box at home. I already have 8.1.7 EE, Forms 4.5/5.0/6i, and tons of other stuff installed. I've read through the install guide, the various release notes, etc and never came across that. But, if it is so, I don't intend to waste a perfectly good day trying to get things to work. ya. please let me know what you find out. ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: stupid DBA
This was mean. --- "Eric D. Pierce" [EMAIL PROTECTED] wrote: Ever considered trying out for fighter pilot in the chinese air force? I think they have an opening. On 13 Apr 2001, at 14:45, Robert Chen wrote: Date sent:Fri, 13 Apr 2001 14:45:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ...I am considering to change to be a nurse associate or something like that. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PK J 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: stupid DBA
Oh, I thought this was a personal message to me. At least that is how our applications people refer to the DBAs whenever THEY screw up. Denise Gwinn [EMAIL PROTECTED] -- 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 get rid off file permanently?
Eric, Are you feeling alright? This is possibly the shortest, most succinct answer I have ever seen you post! :) Rachel From: "Eric D. Pierce" Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: RE: How to get rid off file permanently? Date: Fri, 13 Apr 2001 14:00:33 -0800 delicious. :) On 13 Apr 2001, at 13:40, Gogala, Mladen scribbled with alacrity and cogency: ... As a DBA and a gentleman I can not but take pride in helping people to stop making mistakes. next: ... John Leo on CSPAN. As you may recall, he is the columnist from "U.S. News and World Report" who gave CSUS President Gerth the 1999 "Sheldon Award" for political correctness. ( http://www.usnews.com/usnews/issue/000103/03john.htm ). ---excerpt--- ... The coveted annual prize that goes to a wimpy college president Exhausted staffers for this column have finished wading through dozens of nominees for the third annual Sheldon Award. Named for Sheldon Hackney, who scaled the heights of Sheldonism as president of the University of Pennsylvania, this coveted prize is given each year to a craven college president who looks the other way while campus newspapers are stolen. ... ---end--- ... on CSPAN, John Leo (warm, mild, grandfatherly, caring, thoughtful, principled [witty]) was talking about the topics in his new book "Incorrect Thoughts" at an event organized by the Independent Women's Forum. Since IWF's (very interesting) web site hasn't been updated recently, I found some other links about Leo's book that you might also find interesting. http://www.iwf.org - John Leo's columns: http://www.jewishworldreview.com/cols/leo1.asp - (and: http://www.usnews.com/usnews/opinion/jleo.htm ) http://www.jewishworldreview.com/cols/leo031201.asp excerpt from the above link: ... That notion that free speech is a tool of the oppressor is now mainstream in the campus culture. This is why campus newspapers with the wrong news keep getting stolen, posters for the wrong events keep getting torn down, and speakers with the wrong views keep getting disinvited or silenced. Recent nonspeakers at Berkeley, home of the free-speech movement, include conservative organizer Daniel Flynn (shouted down) and former Israeli Prime Minister Binyamin Netanyahu (threats of violence, advised to withdraw by police). Berkeley gets another chance to oppose free speech this week. David Horowitz is scheduled to speak there on March 15 (end excerpt) http://www.usnews.com/usnews/issue/000612/12john.htm excerpt from the above link: ... Post-1960s liberalism has lost its communal sensibility and now talks almost exclusively of autonomy and rights, not obligation or moral accountability. As Stein [_How I Accidentally Joined the Vast Right-Wing Conspiracy: (And Found Inner Peace)_] points out, it has aggressively labored to devalue society by trying to banish moral and religious discourse from the public arena. Values are viewed as matters of personal taste. Even the famous liberal belief in openness, tolerance, and free speech now looks like a discarded tenet. Witness all the disinvited speakers, stolen newspapers, and current not-very-liberal efforts to silence Laura Schlessinger and derecognize campus Christian groups. What passes for liberalism now, Stein says, is often an attempt to impose rectitude, "usually with the active cooperation of the news media, government agencies, and Hollywood, all of which somehow get to call their own agenda 'inclusive' instead of 'narrow.' " (end excerpt) more at: http://www.google.com/search?q=john+leo+incorrect+thoughts --- also: http://www.gseis.ucla.edu/courses/ed191/assignment1/1970illich.html excerpt: ... According to Illich, "obligatory instruction assumes the belief that man can do what God cannot, namely, manipulate others for their own salvation" (1970, p.50). By deschooling society, schools would continue to exist but their workings would be very different from those operating at present. Deschooling could only occur given alternative social arrangements and legal protections as well as a reconceptualization of what constitutes learning in the heart of every deschooled person. According to Illich, schools are the "reproductive organ of a consumer society" (1970). Schools produce myths upon which an economic society depends. Schooling is a ritual performed by participants who are made blind to the discrepancy between the purpose for and the consequences of the ritual. Despite the advertised purpose of promoting social equality and democratic participation, schooling is "the ritual of a society committed to progress and development" (Cayley, 1992, p. 67). In his thesis titled, Deschooling Society, Ivan Illich promulgates four myths created by the school ritual; 1) the myth of unending consumption, 2) the myth of measurement of values, 3) the myth of packaging values, and 4) the myth of
Re: stupid DBA
and the original post was not?? From: PK J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid DBA Date: Fri, 13 Apr 2001 16:55:19 -0800 This was mean. --- "Eric D. Pierce" [EMAIL PROTECTED] wrote: Ever considered trying out for fighter pilot in the chinese air force? I think they have an opening. On 13 Apr 2001, at 14:45, Robert Chen wrote: Date sent: Fri, 13 Apr 2001 14:45:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ...I am considering to change to be a nurse associate or something like that. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PK J 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: stupid DBA
http://www.darwinawards.com excerpt: Literary Reference The existence of Darwin Awards shows that we apparently do need common sense warnings like, "Caution: Batman cape does not enable wearer to fly." ([from:] Greg Hanes [mailto:[EMAIL PROTECTED]]) On 13 Apr 2001, at 17:25, [EMAIL PROTECTED] wrote: Date sent: Fri, 13 Apr 2001 17:25:19 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Oh, I thought this was a personal message to me. At least that is how our applications people refer to the DBAs whenever THEY screw up. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: stupid DBA
LOL.. That guy deserves the 'Darwin' award. Flying like that under the a wing of bigger plane As for the original poster... the signature tells the real story (if it is really real,that is). -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 6:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: stupid DBA Ever considered trying out for fighter pilot in the chinese air force? I think they have an opening. On 13 Apr 2001, at 14:45, Robert Chen wrote: Date sent:Fri, 13 Apr 2001 14:45:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ...I am considering to change to be a nurse associate or something like that. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Deshpande, Kirti 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: Performance Degradation/anomaly?
Mladen, Thanks very much for responding to this. I was leafing thru' a tuning book and it suggest checking the types of metrics az mentioned by you. I suspect the db parameters needs some tuning. Regards, Ed --- "Gogala, Mladen" [EMAIL PROTECTED] wrote: Ed, try looking in the v$session_wait to see what is the session waiting for. That should give you a hint on what might be going on. If you cannot find anything in the database, check OS, swapping, paging, CPU, queues on the disk drives etc -Original Message- Sent: Friday, April 13, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Greetings all, This is more of a tuning question. We have a pl/sql procedure doing inserts and updates to a very large table. This procedure process different groups of same types of data sequentially. The difference between these groups is with the volume of raw data. When the procedure gets to process a large dataset (large volume), the performance slows significantly. However, it will speed up when it gets to process a smaller dataset. The clincher: If I was to terminate and re-start the procedure the performance picks up for the same large dataset. It behave as though the buffer is "full" and the re-start seems to clear the buffer or any "cow webs" from previous session. The procedure has been tuned. The target table has recently been defragmented. No other processes running concurrently. We suspect the database needs tuning but do not know how to proceed. What should we be looking for? I am hoping to get suggestions on what to do to tune the DB. Appreciate any feedback. Thanks very much, Ed __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Gogala, Mladen 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: stupid DBA
well.. "ever" might be pushing it a bit... but yes, it was funny :) From: "Paul Baumgartel" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid DBA Date: Fri, 13 Apr 2001 18:50:55 -0800 Eric's post was the funniest thing I have ever read on this list. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 10:05 PM and the original post was not?? From: PK J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid DBA Date: Fri, 13 Apr 2001 16:55:19 -0800 This was mean. --- "Eric D. Pierce" [EMAIL PROTECTED] wrote: Ever considered trying out for fighter pilot in the chinese air force? I think they have an opening. On 13 Apr 2001, at 14:45, Robert Chen wrote: Date sent: Fri, 13 Apr 2001 14:45:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ...I am considering to change to be a nurse associate or something like that. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PK J 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Paul Baumgartel 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
Imp relationship tables
Hi all, What are the steps required to perform full imp from full export dump file. Because there are FK constraints currently my steps are: 1. perform full exp with system/manager in other machine 2. disable all constraints 3. truncate all tables 4. perform full imp with system/manager 5. enable all constraints any better way, I feel there are some leak there, help me please Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
OT -- Friday recipe (barely on time)
this recipe was originally for a "traditional" layer cake with cream cheese frosting. Since I hate cream cheese frosting, I changed the recipe a bit... makes a much better addition to a Sunday brunch, IMHO Enjoy folks! CARROT CAKE (makes 1 loaf 6 muffins) Ingredients: 1 lb carrots (approximate) 1 cup brown sugar 1/3 cup white sugar 3/4 cup oil 3 large eggs 1 1/3 cups flour 1 1/3 tsp baking pwoder 1 1/3 tsp baking soda 1/3 tsp salt 1/2 cup coarsely chopped walnuts (or to taste, I add more) Instructions: 1. Preheat oven to 325. 2. Trim, scrape grate carrots -- measure 2 cups. 3. Combine sugar oil in bowl of electric mixer. 4. Start beating add eggs one at a time, beating well. 5. Sift together flour, baking powder, baking soda salt. 6. Add flour mix gradually to oil mixture while beating. 7. Fold in carrots nuts and blend well. 8. Lightly oil 1 loaf pan 6 muffin cups. 9. Line bottoms with wax paper, oil paper. 10. Pour batter into pans. 11. Place in oven bake 45-60 minutes or until top sets. 12. Turn cake onto wire racks and let cool. 13. Remove paper liners. Note: use a HEAVY DUTY mixer (I have a KitchenAid professional model) as once you add in the flour and before you add the carrots the batter is very very stiff... I've burned out handheld mixers on this batter _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
crontab script problem
Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).