Import/Export table
Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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: Datawarehouse Sizes.....informal poll.
I've been bodging my way though setting up a database to hold summary info for 11 million assets with various look-up tables around it, the whole to be refreshed weekly. Its not that big - around 15Gb, it doesn't have a timestamp as the partition key and it does not contain transaction info, but when I look at the Oracle DW documentation, lo-and-behold - many of the concepts and techniques apply - bitmap indexes, partitioning, 'fact' and 'dimension' tables, ETT, etc. 'A rose by any other name would smell as sweet' -- David Lord -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 21:55 To: Multiple recipients of list ORACLE-L Subject: Datawarehouse Sizes.informal poll. Informal survey: Datawarehousing. Limiting Assumption: A necessary and sufficient condition for defining something to be a datawarehouse is the amount of data to be stored. Question/Poll: Given the above ridiculous constraint, at/above what size can something be considered a data warehouse? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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). ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS 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).
Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications
Hi Gurus, I need to update the OS from Unix 2.6 to 2.8 on my database and form servers. We are running Oracle HRMS Applications 11I Version 11.5.1. Has anyone done it before ? Any advice ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Import/Export table
Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix account from PL/SQL ??
Hi Sunny, Thanks for your help. It seems to be the answered for me ;) But I still hit one problem here, I tried to invoke the SQL statement from my package. and when I compile the package, It keeps giving me the error message : PLS-00201: identifier 'SYS.V_$SESSION' must be declared any idea what could be the problem ? Another question, What is the safe way to switch to another user in the shell script ? if I use su oracle or su - oracle, normally it will prompt me for the password. How do I do that in the shell script, Do I need to include the password as well ? Won't that be dangerous ? Thanks a lot Sunny Regards Herman - Original Message - To: [EMAIL PROTECTED] Sent: Saturday, December 08, 2001 12:24 AM Hello Herman, Correction : select osuser into from v$session where audsid = userenv('sessionid'); should give you the unix userid from within pl/sql For the second question, I think it's called the Sticky bit setting on a file's permissions where it basically does a switch user to the owner before executing it. So regardless of who in the group runs oracle, it will be run as Oracle. thanks, Sunny From: Herman Susantio [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Unix account from PL/SQL ?? Date: Thu, 06 Dec 2001 18:25:18 -0800 Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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: Import/Export table
Use this. exp scott/tiger tables=(t1,t2,t3) Owner=scott Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Monday, December 10, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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: Ganesh Raja 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 account from PL/SQL ??
Hi jesse, For no 1, Thanks a million, it works fine For no 2, yes, I saw the sticky bit in the oracle file. is it advisable for us to change the oracle file permission / to turn off the sticky bit ? Would it affect oracle internally ? Thanks for Sunny too, I'm also still curious why I can't access v$session from the package , any idea ? Regards - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 11:10 PM Assuming you're on Oracle 8i (you don't say): 1) select SYS_CONTEXT('USERENV','OS_USER') from dual; 2) I believe this is because the $ORACLE_HOME/bin/oracle executable has an owner of oracle and has the sticky bit set on it's security. If you ls -l $ORACLE_HOME/bin/oracle, you should see the security on the file as -rwsr-s--x, with the s being the sticky bit. Try a man chmod for more info. HTH! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, December 06, 2001 20:25 To: Multiple recipients of list ORACLE-L Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Herman Susantio 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: Import/Export table
You can export the tables in Table level export and then import it to the target database. As suggested by GopalKrishnan, if the names are different you may have to use FROMUSER TOUSER during the import. -Original Message- Gopalakrishnan Sent: Monday, December 10, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale 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 account from PL/SQL ??
You can use remote login rlogin and run the shell script which you need to run on the remote Unix machine. You dont have to pass any password while using rlogin command. See the help for rlogin for how to set it up.. -Original Message- Susantio Sent: Monday, December 10, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi Sunny, Thanks for your help. It seems to be the answered for me ;) But I still hit one problem here, I tried to invoke the SQL statement from my package. and when I compile the package, It keeps giving me the error message : PLS-00201: identifier 'SYS.V_$SESSION' must be declared any idea what could be the problem ? Another question, What is the safe way to switch to another user in the shell script ? if I use su oracle or su - oracle, normally it will prompt me for the password. How do I do that in the shell script, Do I need to include the password as well ? Won't that be dangerous ? Thanks a lot Sunny Regards Herman - Original Message - To: [EMAIL PROTECTED] Sent: Saturday, December 08, 2001 12:24 AM Hello Herman, Correction : select osuser into from v$session where audsid = userenv('sessionid'); should give you the unix userid from within pl/sql For the second question, I think it's called the Sticky bit setting on a file's permissions where it basically does a switch user to the owner before executing it. So regardless of who in the group runs oracle, it will be run as Oracle. thanks, Sunny From: Herman Susantio [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Unix account from PL/SQL ?? Date: Thu, 06 Dec 2001 18:25:18 -0800 Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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: Rahul Mehendale 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 account from PL/SQL ??
You can use remote login rlogin and run the shell script which you need to run on the remote Unix machine. You dont have to pass any password while using rlogin command. See the help for rlogin for how to set it up.. -Original Message- Susantio Sent: Monday, December 10, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi Sunny, Thanks for your help. It seems to be the answered for me ;) But I still hit one problem here, I tried to invoke the SQL statement from my package. and when I compile the package, It keeps giving me the error message : PLS-00201: identifier 'SYS.V_$SESSION' must be declared any idea what could be the problem ? Another question, What is the safe way to switch to another user in the shell script ? if I use su oracle or su - oracle, normally it will prompt me for the password. How do I do that in the shell script, Do I need to include the password as well ? Won't that be dangerous ? Thanks a lot Sunny Regards Herman - Original Message - To: [EMAIL PROTECTED] Sent: Saturday, December 08, 2001 12:24 AM Hello Herman, Correction : select osuser into from v$session where audsid = userenv('sessionid'); should give you the unix userid from within pl/sql For the second question, I think it's called the Sticky bit setting on a file's permissions where it basically does a switch user to the owner before executing it. So regardless of who in the group runs oracle, it will be run as Oracle. thanks, Sunny From: Herman Susantio [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Unix account from PL/SQL ?? Date: Thu, 06 Dec 2001 18:25:18 -0800 Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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: Rahul Mehendale 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: Import/Export table
Thanks. Still have another questions. - When importing can I change the original tables name? - I try exp80imp80 and besides the tables I saw that the import tool get the constraints related to those tables. Can I import only the structeuredata of the table without indexes and any other objects connected with those tables. Anyway even without these I managed to export/import the tables so I appreciate you all for the helping hand. Iulian -Original Message- Sent: Monday, December 10, 2001 1:15 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** You can export the tables in Table level export and then import it to the target database. As suggested by GopalKrishnan, if the names are different you may have to use FROMUSER TOUSER during the import. -Original Message- Gopalakrishnan Sent: Monday, December 10, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale 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
FW: DANP
All, Oracle 8.0.5.0.0 on Tru64 Unix v4.0f Anyone seen anything like this before ?? I've never seen a negative number before. I'm assuming its a bug/feature Regards Lee TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK MINX NUMXMAXX SHRINAVACTK -- --- --- --- - - - --- - - RBSRBS05ONLINE81920 81920 1064952 1064952 2 13 505 0 0 RBSRBS06ONLINE81920 81920573432 573432 27 505 0 0 RBSRBS07ONLINE81920 81920 -1490952-1490952 2 33 505 0 0 RBSRBS08ONLINE81920 81920 1720312 1720312 2 21 505 0 0 SYSTEM SYSTEM ONLINE 56 56 392 392 25 505 0 0 The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import/Export table
Yes, you can import without constraints / indexes. exp80 help=y, imp80 help=y will give you a list of the valid command-line options for export and import. [EMAIL PROTECTED] wrote: Thanks. Still have another questions. - When importing can I change the original tables name? - I try exp80imp80 and besides the tables I saw that the import tool get the constraints related to those tables. Can I import only the structeuredata of the table without indexes and any other objects connected with those tables. Anyway even without these I managed to export/import the tables so I appreciate you all for the helping hand. Iulian -Original Message- Sent: Monday, December 10, 2001 1:15 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** You can export the tables in Table level export and then import it to the target database. As suggested by GopalKrishnan, if the names are different you may have to use FROMUSER TOUSER during the import. -Original Message- Gopalakrishnan Sent: Monday, December 10, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale 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 /
Oracle Designer Connection with server
Hi List, I am in a problem, not being able to connect from designer/developer to the oracle db. Environment PlatformWindows NT 4.0 Service Pack 6a - standalone server DBOracle 8.1.6 EE Designer6i Developer 6i As suggested in the release notes of Designer, I have first installed the Designer in the default_home and then installed the database in a different home. Developer was installed subsequently in the same home where designer was installed. My database works fine from SQL*Plus. But when, I tried to connect either from designer or developer, I am getting TNS could not resolve service name. I had created an alias using net easy config. I am getting the same above error when i tried to connect while using the alias as the service name. Could anyone shed some light to resolve this to connect from Designer/Developer, Thanks in Advance, Muths ps: I am posting this here as some one who could help me, who have not subscribed to the DEV2K list.
Re: DANP
Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than 8K isn't it? Regards, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:55 PM All, Oracle 8.0.5.0.0 on Tru64 Unix v4.0f Anyone seen anything like this before ?? I've never seen a negative number before. I'm assuming its a bug/feature Regards Lee TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK MINX NUMXMAXX SHRINAVACTK -- --- --- --- - - - --- - - RBSRBS05ONLINE81920 81920 1064952 1064952 2 13 505 0 0 RBSRBS06ONLINE81920 81920573432 573432 27 505 0 0 RBSRBS07ONLINE81920 490952-1490952 2 33 505 0 0 RBSRBS08ONLINE81920 81920 1720312 1720312 2 21 505 0 0 SYSTEM SYSTEM ONLINE 56 56 392 392 25 505 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: DANP
Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee -Original Message- Sent: 10 December 2001 12:40 To: Multiple recipients of list ORACLE-L Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than 8K isn't it? Regards, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:55 PM All, Oracle 8.0.5.0.0 on Tru64 Unix v4.0f Anyone seen anything like this before ?? I've never seen a negative number before. I'm assuming its a bug/feature Regards Lee TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK MINX NUMXMAXX SHRINAVACTK -- --- --- --- - - - --- - - RBSRBS05ONLINE81920 81920 1064952 1064952 2 13 505 0 0 RBSRBS06ONLINE81920 81920573432 573432 27 505 0 0 RBSRBS07ONLINE81920 490952-1490952 2 33 505 0 0 RBSRBS08ONLINE81920 81920 1720312 1720312 2 21 505 0 0 SYSTEM SYSTEM ONLINE 56 56 392 392 25 505 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Installing dual versions of Oracle on Win2K
I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server shortly. The 7.3.4 is so that we have an accurate version of the old database which is being migrated to 8.1.6 (which explains the 8.1.6). I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before 8.1.6. I'm hoping the 8.1.6, with it's dual home utility, will not step on the registry settings for 7.3.4. Has anyone done this and have any heads up for me? Thanks -- 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: Cannot Drop Column
Is this in a DBA table? If so, which one? Thanks, Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 12/07/01 02:25PM Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Ken Janusz 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
tablespace in backup mode
Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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).
Init.ora Compabible Setting
My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Cannot Drop Column
I checked compatible in init.ora and it is set to 8.1.0. Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 12/07/01 02:25PM Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Ken Janusz 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
RE: Datawarehouse Sizes.....informal poll.
Dennis, Thanks for the thoughts, the historical snapshot, and for paying attention to the question. I am on the DW list now, and will newby-ize them straight away. - Ross -Original Message- Sent: Friday, December 07, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Ross - Still hung up on size hmmm. How about this for a definition. A data warehouse encompasses data for the entire organization. A data mart services data for a portion of the organization. The history of this subject is relevant. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Where is the memory gone?
Only thing I have to add here is that I was not using MTS so which ever bug I was hitting (doco is at the office) it was not related to that. -Original Message- Sent: Sunday, December 09, 2001 9:50 PM To: Multiple recipients of list ORACLE-L WinterSun, Hmm, this doesn't sound like bug 1397603. That bug manifests itself as a memory leak in the 'State objects' area of the shared pool, not the 'Miscellaneous' area. Bug 1397603 is also fixed in the 8.1.7.2 patchset, so if you already have that applied (hint, hint!) you're not encountering this bug and there's no need to set _db_handles_cached = 0. I believe the bug Kimberly is referring to is bug 1240484, which is a process memory leak (i.e. ORA-4030, not ORA-4031) with MTS shared server sessions when there are frequent connect/disconnects. That bug is fixed in 8.1.7.1. If IOT's are involved, you could be hitting bug 1642964 if the IOT is the inner table in a nested loop join. Fixed in 9.0.1. Workaround: set optimizer_index_caching = 1 I'm more inclined to believe you're hitting bug 1921561 or bug 1970290, both of which have been awaiting more info from the customer for whom the bug was filed. The workaround for both of them was to set STAR_TRANSFORMATION_ENABLED = FALSE or _db_file_noncontig_mblock_read_count = 1. If you use bitmap indexes, disabling star transformation is likely to cause a noticeable performance hit so you might want to try the other workaround. Otherwise, if you can reproduce this in a test environment, it would be helpful to file a tar with support so a bug can be filed. HTH, -- Anita --- WinterSun Zhao [EMAIL PROTECTED] wrote: Hi, Kimberly: Thank you for your guide. I checked Metalink and find that is a bug. Bug No. 1397603. I think I will add the parameter _db_handles_cached to 1 later. I will also patch it to 8.1.7.2 too. Thank all of you. B.R. This sound pretty much like the same problem I had with 8.1.7 on HP. They have a memory leak when you connect/disconnect and it you have a lot of those you start to see it in your SGA. I had to patch to 8.1.7.1 plus an additional bug fix. Check on Metalink to see if there is the same problem with Windows. It also could be that you really do need more then 50M. Pin in the bigger packages you use (including Oracle's) right after startup and see where you are memory wise. -Original Message- Zhao Sent: Sunday, December 09, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Hi, DBAs: I find that one of our database's Shared Pool's memory decreased every day. It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory. When I check v$sgastat, I find the miscellaneous part of shared pool increased every day, it begans with 500K, then, after two days, it increased to 5586228 bytes, after about 10 days, it increased to 40M, and because I had allocated 50M to the Shared Pool, So the memory available became less and less. And I had to shutdown and restart the database when the available memory of shared pool is below 5M. I want to know why the memory occupied by miscellaneous part is increased? The other database on solaris did not increased. How can I find out what is it? How to prevent it or resolve it without shutdown and restart the database? ( alter system flush shared pool only flush the sql and library cache, and it didn't decrease the miscellaneous part's memory usage. ) Thank you very much! WinterSun __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Init.ora Compabible Setting
Ken, If you set the compatible to 817, then, you would be able to take advantage of 817 version. Or, if you have some software which is compatible with 8.1.0, then, it is better to leave like that. I personally prefer setting it to 817. Rao -Original Message- Sent: Monday, December 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Rao, Maheswara 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: Import/Export table
Use the fromuser touser parameters. Better yet, read a manual. -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing dual versions of Oracle on Win2K
I'm sure someone has done this, BUT, 7.3.4 is NOT supported on Win2k. John [EMAIL PROTECTED] wrote: I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server shortly. The 7.3.4 is so that we have an accurate version of the old database which is being migrated to 8.1.6 (which explains the 8.1.6). I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before 8.1.6. I'm hoping the 8.1.6, with it's dual home utility, will not step on the registry settings for 7.3.4. Has anyone done this and have any heads up for me? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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: tablespace in backup mode
Title: RE: tablespace in backup mode Charlie Select status from V$backup. If status = 'ACTIVE' then tablespace in hot backup mode HTH John -Original Message- From: Charlie Mengler [mailto:[EMAIL PROTECTED]] Sent: 10 December 2001 14:26 To: Multiple recipients of list ORACLE-L Subject: tablespace in backup mode Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
Re: tablespace in backup mode
Check V$BACKUP view, and look at the status column. This tells if the files of the tbs were left in hot backup mode. Susan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 10:25 AM Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Susan M. Trumpet 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: DANP
Thanks Ed, I just got this from MetaLink, looks like you were spot on. A quick check showed me that the offending RBS was more than 2Gb. Cheers Lee Doc ID: Note:100292.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 28-FEB-2000 Last Revision Date: 24-APR-2001 Problem Description --- Selecting records from V$ROLLSTAT, you may see that some columns have negative values like HWMSIZE column for example. Due to [BUG:668924], these columns cannot record values larger than 2GB (2 147 483 647). If the value is greater than that, value turns negative. This error doesn't prevent Rollback Segment to grow larger than this value. It's just a recording problem in V$ROLLSTAT. Solution Description This bug is fixed in 8.0.6 and 8.1.6. You can upgrade to one of these two RDBMS versions to fix the problem. At this point the maximum value will be 4 GB (4 294 967 295). Workarounds: 1. Check Storage Clause Check that no storage option implies in any column a value greater than 2 GB (like RSSIZE and so HWMSIZE for example). If so, either alter the storage clause or drop and recreate the rollback segment with a smaller initial size (initial_extent * min_extents). If you don't want negative values to appear in rssize, writes, hwmsize, at any moment, set max_extents to the right value. Warning : Doing so, you will prevent success of transactions generating more than 2GB of undo. So you should probably modify such transactions. 2. Negative values will disappear at next instance start if not initial storage values. As v$rollstat is a dynamic performance table which is reset at each instance start, at next instance start negative values will disappear if these negative values are not due to initial size of Rollback Segment. -Original Message- Sent: 10 December 2001 15:10 To: Robertson Lee - lerobe; [EMAIL PROTECTED] Sorry Lee, I made a mistake. I was looking through russian confs. It seems it appears when size of your rollback segment is more than 2Gb. Regards, Ed Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than 8K isn't it? The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tablespace in backup mode
This should do the trick select d.file#, t.name,b.status from v$datafile d,v$tablespace t, v$backup b where d.ts# = t.ts# and d.file# = b.file# and b.status = 'ACTIVE' Regards Lee -Original Message- Sent: 10 December 2001 14:26 To: Multiple recipients of list ORACLE-L Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tablespace in backup mode
Title: RE: tablespace in backup mode check the STATUS column in v$backup Matt Adams - GE Appliances - [EMAIL PROTECTED] If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood. -Original Message- From: Charlie Mengler [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Subject: tablespace in backup mode Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: DANP
Sorry Lee, I made a mistake. I was looking through russian confs. It seems it appears when size of your rollback segment is more than 2Gb. Regards, Ed Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than 8K isn't it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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).
Parallel export by datafile/extent
Hello all, I'm trying to generate a script that generates many export parameter files, each one of which would export a subsection of a table based on it's datafile. I think this is possible using sql-extended query export and rowid ranges. The idea of course is to then kick off each of those exports simultaneously. It'll be a small job though, and I thought I would post to see if anyone has done anything like this before? Thanks, Paul ---www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more.
RE: Installing dual versions of Oracle on Win2K
Other than 7.3.4 isn't supported for Windows 2000. I have ran into issues where imports and exports take FOREVER...and when I say forever, I do mean it. I had one export that was approx 350meg, take about 13 hours. I have also ran into DLL issues with C++ programs as well. thanks, C- -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 7:20 AM To: Multiple recipients of list ORACLE-L I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server shortly. The 7.3.4 is so that we have an accurate version of the old database which is being migrated to 8.1.6 (which explains the 8.1.6). I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before 8.1.6. I'm hoping the 8.1.6, with it's dual home utility, will not step on the registry settings for 7.3.4. Has anyone done this and have any heads up for me? Thanks -- 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: Christine Turner 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: tablespace in backup mode
Charlie, Select * from v$backup; If any tablespace is left in backup mode, then, you would see --- ACTIVE --- under the column status. Rao -Original Message- Sent: Monday, December 10, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Rao, Maheswara 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: Where is the memory gone?
Answering your first message about the shrink of free space in shared pool. Check the parsing ratio: The hard parse with something like this SELECT substr(sql_text,1,40) SQL, count(*) , sum(executions) TotExecs FROM v$sqlarea WHERE executions 5 GROUP BY substr(sql_text,1,40) HAVING count(*) 30 ORDER BY 2 ; The soft parsing something like this: select count(*) from v$sqlarea where version_count5; And about parsing look for a note in metalink about parameter _sqlexec_progression_cost. Try with cursor_sharing. Also refer to possibles bugs related in metalink. And about parsing you can also look in the v$sysstat for statistics related. Check the shared pool latch rate too. Regards. --- Kimberly Smith [EMAIL PROTECTED] wrote: Only thing I have to add here is that I was not using MTS so which ever bug I was hitting (doco is at the office) it was not related to that. -Original Message- Sent: Sunday, December 09, 2001 9:50 PM To: Multiple recipients of list ORACLE-L WinterSun, Hmm, this doesn't sound like bug 1397603. That bug manifests itself as a memory leak in the 'State objects' area of the shared pool, not the 'Miscellaneous' area. Bug 1397603 is also fixed in the 8.1.7.2 patchset, so if you already have that applied (hint, hint!) you're not encountering this bug and there's no need to set _db_handles_cached = 0. I believe the bug Kimberly is referring to is bug 1240484, which is a process memory leak (i.e. ORA-4030, not ORA-4031) with MTS shared server sessions when there are frequent connect/disconnects. That bug is fixed in 8.1.7.1. If IOT's are involved, you could be hitting bug 1642964 if the IOT is the inner table in a nested loop join. Fixed in 9.0.1. Workaround: set optimizer_index_caching = 1 I'm more inclined to believe you're hitting bug 1921561 or bug 1970290, both of which have been awaiting more info from the customer for whom the bug was filed. The workaround for both of them was to set STAR_TRANSFORMATION_ENABLED = FALSE or _db_file_noncontig_mblock_read_count = 1. If you use bitmap indexes, disabling star transformation is likely to cause a noticeable performance hit so you might want to try the other workaround. Otherwise, if you can reproduce this in a test environment, it would be helpful to file a tar with support so a bug can be filed. HTH, -- Anita --- WinterSun Zhao [EMAIL PROTECTED] wrote: Hi, Kimberly: Thank you for your guide. I checked Metalink and find that is a bug. Bug No. 1397603. I think I will add the parameter _db_handles_cached to 1 later. I will also patch it to 8.1.7.2 too. Thank all of you. B.R. This sound pretty much like the same problem I had with 8.1.7 on HP. They have a memory leak when you connect/disconnect and it you have a lot of those you start to see it in your SGA. I had to patch to 8.1.7.1 plus an additional bug fix. Check on Metalink to see if there is the same problem with Windows. It also could be that you really do need more then 50M. Pin in the bigger packages you use (including Oracle's) right after startup and see where you are memory wise. -Original Message- Zhao Sent: Sunday, December 09, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Hi, DBAs: I find that one of our database's Shared Pool's memory decreased every day. It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory. When I check v$sgastat, I find the miscellaneous part of shared pool increased every day, it begans with 500K, then, after two days, it increased to 5586228 bytes, after about 10 days, it increased to 40M, and because I had allocated 50M to the Shared Pool, So the memory available became less and less. And I had to shutdown and restart the database when the available memory of shared pool is below 5M. I want to know why the memory occupied by miscellaneous part is increased? The other database on solaris did not increased. How can I find out what is it? How to prevent it or resolve it without shutdown and restart the database? ( alter system flush shared pool only flush the sql and library cache, and it didn't decrease the miscellaneous part's memory usage. ) Thank you very much! WinterSun __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
truncate or drop
Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
KSH Scripting Questions
I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: truncate or drop
do you like the existing placement and storage clauses of the tables? -Original Message- Sent: Monday, December 10, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Mohan, Ross 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: truncate or drop
Ruth: I would think you would want to truncate which deletes all the data and resets the high water mark. Dropping the tables? I think this destroys the table? Then you have to recreate all the tables from a DDL SQL script. Ken -Original Message- Sent: Monday, December 10, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Subject:truncate or drop Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Ken Janusz 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: KSH Scripting Questions
wait ? -Original Message- Sent: Monday, December 10, 2001 11:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Mohan, Ross 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: truncate or drop
Both could be slowly if tables have many extents and you use extent management dictionary. However I think drop would be a little more expensive considering that not only it has to erase info from uet$ and fet$, also from basically c_obj# and others clusters. Regards. --- Ruth Gramolini [EMAIL PROTECTED] wrote: Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: truncate or drop
Title: RE: truncate or drop Truncate and then drop empty tables. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Subject: truncate or drop Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Number 333
Heh! :( just trying to get the ball rolling! regards, ep On 7 Dec 2001, at 17:18, [EMAIL PROTECTED] wrote: Is that the best you can do? ;) I recall something from the list many years ago where a poster was asking for help with a SQL statement that was unbelievably long. If I recollect correctly, it was about a 64K single SQL statement. It doesn't seem like maintaining something like that would actually be possible. ... -- 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).
exp/imp unable to create unix index
Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported importing table PA_PROJECTS_ALL 3160 rows imported exporting tablePO_VENDORS 57688 rows exported importing table PO_VENDORS 57688 rows imported Why, any idea? Mitchell This is the log from imp. IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PA_PROJECTS_U3 ON PA_PROJECTS_ALL (NAME ) PCTFRE E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL D EFAULT) TABLESPACE PAX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PO_VENDORS_U2 ON PO_VENDORS (VENDOR_NAME ) PCTFR EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 MINEXTENT S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE POX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: truncate or drop
Title: RE: truncate or drop If they have thousands of extents... it might be better to truncate first, then drop. I've seen it take up to 4-5 hours to drop a table with thousands of extents (not my database... but a clients.) :) If you are going to rebuild entire datafiles/tablespaces... it might just be faster to take them offline and drop them. Then rebuild the new datafiles. If it is the entire database... rebuild it from scratch... Hope this helps. Nick -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 8:40 AM To: Multiple recipients of list ORACLE-L Subject: truncate or drop Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: KSH Scripting Questions
Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any subprocesses you've kicked off and then kill them as you please. IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use is nohup. And you probably want it to run in the background so that your processing can continue. Your command is nohup monitor -flags HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Bellows, Bambi 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 account from PL/SQL ??
You must login as sys and grant select on v_$session to PACKAGE_OWNER; Please take a look at www.orafaq.com as it will answer all of the questions you've asked. Jared Herman SusantioTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sherman@bcsis cc: .comSubject: Re: Unix account from PL/SQL ?? Sent by: [EMAIL PROTECTED] om 12/10/01 02:05 AM Please respond to ORACLE-L Hi jesse, For no 1, Thanks a million, it works fine For no 2, yes, I saw the sticky bit in the oracle file. is it advisable for us to change the oracle file permission / to turn off the sticky bit ? Would it affect oracle internally ? Thanks for Sunny too, I'm also still curious why I can't access v$session from the package , any idea ? Regards - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 11:10 PM Assuming you're on Oracle 8i (you don't say): 1) select SYS_CONTEXT('USERENV','OS_USER') from dual; 2) I believe this is because the $ORACLE_HOME/bin/oracle executable has an owner of oracle and has the sticky bit set on it's security. If you ls -l $ORACLE_HOME/bin/oracle, you should see the security on the file as -rwsr-s--x, with the s being the sticky bit. Try a man chmod for more info. HTH! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, December 06, 2001 20:25 To: Multiple recipients of list ORACLE-L Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Herman Susantio 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:
RE: truncate or drop
In my view a Truncate is always faster than a Drop. Also, the original table structures of the table r preserved. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 December 2001 16:40 To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
AW: ORA-12545 WHEN CREATING A NEW DATABASE
Title: Nachricht Hi Bunyamin, let dbassistant create scripts for your database. Then edit your listener.ora and tnsnames.ora and add entries for your new instance. After this edit db create scripts and instead of "connect internal" write "connect internal/your_sys_password@your_new_instance. Works for me. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 8. Dezember 2001 16:15An: Multiple recipients of list ORACLE-LBetreff: ORA-12545 WHEN CREATING A NEW DATABASE Dear Gurus , I have a problem. I have 2 databases on an win2000 machine and want to create the third . When I try to create a database with Database Conf. Assistant , it creates the service and before creating datafiles it gives error ORA-12545 and does not create datafiles although I ignore the error.. I can connect to other two databases from both server and clients . But can not create third DB. Why can this be ? Thank you. Bunyamin Karadeniz
RE: KSH Scripting Questions
put wait in main. then cleanup. sorry for the wordy reply. ;-) -Original Message- Sent: Monday, December 10, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any subprocesses you've kicked off and then kill them as you please. IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use is nohup. And you probably want it to run in the background so that your processing can continue. Your command is nohup monitor -flags HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Bellows, Bambi 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: Mohan, Ross 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).
1 1 ??? Strange problem
Hi, I have noticed this strange error with two different database: 8i and 9i. We have a cgi that worked well under 8i but not under 9i. The problem was here : If MyString = '' Then Return xxx End If ; It never went in. I tried the following : If 'string' = 'string' Then -- never come here End If ; If 1 = 1 Then -- never come here either End If ; I don't understand why. Is this a bug? There was a 8i database previously that behaved in this manner but after a time it solved the problem by itself. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: KSH Scripting Questions
I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson 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).
AW: exp/imp unable to create unix index
Maybe the tables still exist in Prod and have some data inside. Try to drop tables in prod before importing. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: mitchell [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 18:40 An: Multiple recipients of list ORACLE-L Betreff: exp/imp unable to create unix index Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported importing table PA_PROJECTS_ALL 3160 rows imported exporting tablePO_VENDORS 57688 rows exported importing table PO_VENDORS 57688 rows imported Why, any idea? Mitchell This is the log from imp. IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PA_PROJECTS_U3 ON PA_PROJECTS_ALL (NAME ) PCTFRE E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL D EFAULT) TABLESPACE PAX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PO_VENDORS_U2 ON PO_VENDORS (VENDOR_NAME ) PCTFR EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 MINEXTENT S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE POX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: Schoen Volker 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: truncate or drop
everybody is focussing on how quick to destroy without considering what follow on work RBG has to do after the bomb drops. It could be like taking over Kandahar, and leaving warring tribes in control. You'd just be asking for trouble down the road. -Original Message- Sent: Monday, December 10, 2001 12:40 PM To: Multiple recipients of list ORACLE-L In my view a Truncate is always faster than a Drop. Also, the original table structures of the table r preserved. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 December 2001 16:40 To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: Mohan, Ross 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: truncate or drop
Yes, I am doing a truncate...reuse storage and that works very well. Thanks to all! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:15 PM do you like the existing placement and storage clauses of the tables? -Original Message- Sent: Monday, December 10, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Mohan, Ross 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: Ruth Gramolini 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: truncate or drop
Hi, there's an option REUSE STORAGE for TRUNCATE command Regards, Ed Both could be slowly if tables have many extents and you use extent management dictionary. However I think drop would be a little more expensive considering that not only it has to erase info from uet$ and fet$, also from basically c_obj# and others clusters. Regards. --- Ruth Gramolini [EMAIL PROTECTED] wrote: Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Edward Shevtsov 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).
ORA-600
Following 4 documents found for ORA-600 errors on Metalink. Hope this might help someone. Entries found: 4 Showing: 4 Ordered by : Score Direction: Descending 1. ORA-600 Lookup Type: Note Doc ID: 153788.1 Score: 1% Modified Date: 23-NOV-2001 Status: PUBLISHED Platform: Generic Product: Oracle Server - Enterprise Edition 2. Database Administration - Oracle Internal Errors Library Page Index Type: Note Doc ID: 144652.1 Score: 1% Modified Date: 23-NOV-2001 Status: PUBLISHED Platform: Generic issue Product: Generic 3. What is an ORA-600 Internal Error? Type: Note Doc ID: 146580.1 Score: 1% Modified Date: 27-SEP-2001 Status: PUBLISHED Platform: Generic issue Product: Oracle Server - Enterprise Edition 4. How to deal with ORA-600 Internal Errors Type: Note Doc ID: 146581.1 Score: 1% Modified Date: 27-SEP-2001 Status: PUBLISHED Platform: Generic issue Product: Oracle Server - Enterprise Edition Regards MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: 1 1 ??? Strange problem
Perhaps you could post some actual test cases that others could run? Jared Csillag Zsolt starsoft@inte To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rware.hucc: Sent by: Subject: 1 1 ??? Strange problem [EMAIL PROTECTED] om 12/10/01 10:20 AM Please respond to ORACLE-L Hi, I have noticed this strange error with two different database: 8i and 9i. We have a cgi that worked well under 8i but not under 9i. The problem was here : If MyString = '' Then Return xxx End If ; It never went in. I tried the following : If 'string' = 'string' Then -- never come here End If ; If 1 = 1 Then -- never come here either End If ; I don't understand why. Is this a bug? There was a 8i database previously that behaved in this manner but after a time it solved the problem by itself. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Database link
Hi DBAs I have a problem with database links in one of the databases - the name of the link gets us.oracle.com appended to it. create database link test connect to test_user identified by test_pwd using 'test_db' When I execute: select * from my_table@test I get the ORA-02085 error message the the link test.us.oracle.com connects to test. When I execute: select * from global_name; in the target database the result is: TEST but in the database where I created the link the database name has the suffix: NOVALIS.US.ORACLE.COM I have no problem with database links in the TEST database but would like to know which parameter causes the suffix to be appended in the NOVALIS database. In both init.ora files the global_names is set to true and db_domain is commented out. In both databases the command show parameters; returns the db_domain as blank. Actually both databases are on the same server - Oracle 8.1.6. What should I change to remove the US.ORACLE.COM suffix. I don't care too much about the database, it's my test only, but don't want it appended in the links and maybe other objects... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: truncate or drop
Ruth If you drop the table you would have to create it again and would have to deal with security. If you truncate it, the security applied to the table will remain. Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ruth Gramolini Enviado el: Monday, 10 December, 2001 11:40 AM Para: Multiple recipients of list ORACLE-L Asunto: truncate or drop Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Ramon Estevez 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: truncate or drop
Yes, but then remember that it will be necessary a alter table deallocate. Regards. --- Edward Shevtsov [EMAIL PROTECTED] wrote: Hi, there's an option REUSE STORAGE for TRUNCATE command Regards, Ed Both could be slowly if tables have many extents and you use extent management dictionary. However I think drop would be a little more expensive considering that not only it has to erase info from uet$ and fet$, also from basically c_obj# and others clusters. Regards. --- Ruth Gramolini [EMAIL PROTECTED] wrote: Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Edward Shevtsov 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: KSH Scripting Questions
Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson 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 Lange 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).
Database down
ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: KSH Scripting Questions
The monitors are independent. They are used to verify that rcp/rsh programs work correctly. We have been having troubles where rcp and rsh programs fail on one end and never return with a good or bad return code. We wanted the monitor to tell us if the program did not come back in a reasonable times. It does this by checking the existance of a file that is created at the begining of the process and deleting the file at the end of the process. -Original Message- Sent: Monday, December 10, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any subprocesses you've kicked off and then kill them as you please. IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use is nohup. And you probably want it to run in the background so that your processing can continue. Your command is nohup monitor -flags HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Bellows, Bambi 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 Lange 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: truncate or drop
Hmmm, And I thought they were answering the question :-). I would actually do neither unless for some reason I HAD too. In all of the current versions of oracle I would rebuild rebuild this segment. Best regards, John [EMAIL PROTECTED] wrote: everybody is focussing on how quick to destroy without considering what follow on work RBG has to do after the bomb drops. It could be like taking over Kandahar, and leaving warring tribes in control. You'd just be asking for trouble down the road. -Original Message- Sent: Monday, December 10, 2001 12:40 PM To: Multiple recipients of list ORACLE-L In my view a Truncate is always faster than a Drop. Also, the original table structures of the table r preserved. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 December 2001 16:40 To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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 down
I ran into this problem before. oracle had crashed and we could not restart. So , If oracle is truely shut down on that box do an ipcs -m to show all active memory segments. Find the ones owned by oracle and do an ipcrm -M key and remove the shared memory . I did then , then the database could restart just fine. Other than this .reboot the server. -Original Message- Sent: Monday, December 10, 2001 1:25 PM To: Multiple recipients of list ORACLE-L ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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 Lange 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: truncate or drop
I have a script to recreate the tables, however I have used the truncate, reuse storage command with success. We are moving all of our databases onto new servers. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:05 PM Ruth If you drop the table you would have to create it again and would have to deal with security. If you truncate it, the security applied to the table will remain. Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ruth Gramolini Enviado el: Monday, 10 December, 2001 11:40 AM Para: Multiple recipients of list ORACLE-L Asunto: truncate or drop Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Ramon Estevez 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: Ruth Gramolini 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).
SRTIPE SIZE
Hi, We r planning to use RAID 0 What should be stripe size? . I read a document from oracle site mentioning 1M as optimal stripe size. but our SA expert is saying 128k IS ENOUGH. Our hardware support stripe size from 64k to 1M. Sun I/O size is 64K. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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).
RE: Retek ERP ORacle
Title: RE: Retek ERP ORacle Yes. Still on 7.3.4. -Original Message- From: MRaval [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Retek ERP ORacle Anyone in this forum working with Retek ERP. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MRaval 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).
Preventing ORA-1403 in triggers
Hi, So a developer asks me How do I prevent ORA-1403 in my SELECT statement in my trigger? I thought this would be simple, but my brain's just not all here. The statement is simple: SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2 The problem is that we don't know if the user-entered indexcols exist. I could preface this statement with a SELECT count(*) INTO mycount... to see if there are existing rows, but I was hoping to do this all in one SQL statement if possible, especially if/when this scenarios will happen with non-indexed columns (don't ask). Anyone? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 down
There is not enough memory on the server to allocate the shared memory that the init.ora requires. Make you shared_pool smaller and try again. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:25 PM ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Ruth Gramolini 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: KSH Scripting Questions
Yeah, I did that a fair amount, too. It depends on whether you're going to do all your monitoring from your script, or whether you're going to go and fire off a zillion monitors and let them fly on their own. If you're doing it all in the same script, then it becomes easy... for machine in `x y z` do all these things synchronously. If you fire them off until X monitors are running or fire them all off at once to run asynchronously, you need another method to determine what fails and what doesn't. I found that the best way of doing it is to have a unique-log-file-name that gets touched when the rcp/rsh happens and removed when the rcp/rsh terminates, then have another process that sits in a 30 second wait loop to see if any of these processes have been running over Y minutes. Of course, if you want to customize the crap out of it (I always did) you could have the time allowable to be per type or by machine (or both)... for example, if you just want to see if the listener is up, that is going to take much less time to test than if you're running a backup. Anyway, I suspect that you're going to find that nohup is your friend, but that you're not going to want to keep a log of it, because if you're doing what I think you're doing, it's going to get very big very fast. OH. One thing. If you going to have a master process and a waiter in a loop and you're going to run this on multiple machines, you may want to set up a process on a different machine to monitor your master on your main machine, and, if it goes down, copy over all the log files and start the monitoring from the remote machine. Then keep checking to see if you're main machine comes back, and, if so, copy over the logs, quit processing and let your master machine have the reins again. HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 1:31 PM To: Multiple recipients of list ORACLE-L The monitors are independent. They are used to verify that rcp/rsh programs work correctly. We have been having troubles where rcp and rsh programs fail on one end and never return with a good or bad return code. We wanted the monitor to tell us if the program did not come back in a reasonable times. It does this by checking the existance of a file that is created at the begining of the process and deleting the file at the end of the process. -Original Message- Sent: Monday, December 10, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any subprocesses you've kicked off and then kill them as you please. IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use is nohup. And you probably want it to run in the background so that your processing can continue. Your command is nohup monitor -flags HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Bellows, Bambi 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
RE: KSH Scripting Questions
Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 . . . Good Luck, John [EMAIL PROTECTED] 12/10/01 11:30AM Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson 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 Lange 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 Carlson 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: Preventing ORA-1403 in triggers
Rich, Well, just what would you like to do if the record does not exist? You could easily trap the error and move on: begin begin notfound := 'N'; SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2 on exception when no_data_found then notfound := 'Y' end; if notfound = 'Y' then do something... end if; end; You basically can handle all exceptions once you know what it is you want to do if the exception occurs. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 10, 2001 3:02 PM To: Multiple recipients of list ORACLE-L Hi, So a developer asks me How do I prevent ORA-1403 in my SELECT statement in my trigger? I thought this would be simple, but my brain's just not all here. The statement is simple: SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2 The problem is that we don't know if the user-entered indexcols exist. I could preface this statement with a SELECT count(*) INTO mycount... to see if there are existing rows, but I was hoping to do this all in one SQL statement if possible, especially if/when this scenarios will happen with non-indexed columns (don't ask). Anyone? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Preventing ORA-1403 in triggers
IMHO, It is just a matter of catching exceptions in an inner block. This whole lot easier than doing count(*) ... -- initial code -- begin -- inner block begin SELECT description INTO v_desc FROM mytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2; exception when no_data_found -- aka 1403 then null; -- or your favourite action -- end; -- inner block ends ... -- ... continue with remaining code HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Database down
Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: Preventing ORA-1403 in triggers
OK, send your developer back to F(ine) M. There are 2 ways: Trap it begin select description into v_desc from my_table where column=this don't exist ; exception when no_data_found then do some thing else end Or use a cursor cursor csr is select description into v_desc from my_table where column=this don't exist ; begin open csr ; fetch csr into v_desc ; if csr%NOTFOUND then close csr ; do something else ; end if ; close csr; end ; Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any user to continue... Rich.Jesse@qt iworld.com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Preventing ORA-1403 in triggers com 12/10/01 01:01 PM Please respond to ORACLE-L Hi, So a developer asks me How do I prevent ORA-1403 in my SELECT statement in my trigger? I thought this would be simple, but my brain's just not all here. The statement is simple: SELECT description INTO v_desc FROM mytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2 The problem is that we don't know if the user-entered indexcols exist. I could preface this statement with a SELECT count(*) INTO mycount... to see if there are existing rows, but I was hoping to do this all in one SQL statement if possible, especially if/when this scenarios will happen with non-indexed columns (don't ask). Anyone? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Ron Thomas 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: KSH Scripting Questions
That is prety much phase 2.Phase 1 is the simplistic view. The archive process program starts , creates a file, starts the monitor ... does the rsh deletes the file. When the monitor starts ... it sleeps a proscribed time ... then checks the file existance. If its there, it sleeps again (for a specific amount of times). If the file is still there after x times, the monitor e-mails. My trouble is , the main process does not seem to be deleteing its files. I am chaning now on what kind of error messages they are getting. Thanks -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yeah, I did that a fair amount, too. It depends on whether you're going to do all your monitoring from your script, or whether you're going to go and fire off a zillion monitors and let them fly on their own. If you're doing it all in the same script, then it becomes easy... for machine in `x y z` do all these things synchronously. If you fire them off until X monitors are running or fire them all off at once to run asynchronously, you need another method to determine what fails and what doesn't. I found that the best way of doing it is to have a unique-log-file-name that gets touched when the rcp/rsh happens and removed when the rcp/rsh terminates, then have another process that sits in a 30 second wait loop to see if any of these processes have been running over Y minutes. Of course, if you want to customize the crap out of it (I always did) you could have the time allowable to be per type or by machine (or both)... for example, if you just want to see if the listener is up, that is going to take much less time to test than if you're running a backup. Anyway, I suspect that you're going to find that nohup is your friend, but that you're not going to want to keep a log of it, because if you're doing what I think you're doing, it's going to get very big very fast. OH. One thing. If you going to have a master process and a waiter in a loop and you're going to run this on multiple machines, you may want to set up a process on a different machine to monitor your master on your main machine, and, if it goes down, copy over all the log files and start the monitoring from the remote machine. Then keep checking to see if you're main machine comes back, and, if so, copy over the logs, quit processing and let your master machine have the reins again. HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 1:31 PM To: Multiple recipients of list ORACLE-L The monitors are independent. They are used to verify that rcp/rsh programs work correctly. We have been having troubles where rcp and rsh programs fail on one end and never return with a good or bad return code. We wanted the monitor to tell us if the program did not come back in a reasonable times. It does this by checking the existance of a file that is created at the begining of the process and deleting the file at the end of the process. -Original Message- Sent: Monday, December 10, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any subprocesses you've kicked off and then kill them as you please. IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use is nohup. And you probably want it to run in the background so that your processing can continue. Your command is nohup monitor -flags HTH, Bambi. -Original Message- Sent: Monday, December 10, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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
Re: Database link
Witold, Please check sqlnet.ora, try to comment out NAMES.DEFAULT_DOMAIN entry. Also, you can comment out glocal_dbname= in listener.ora file to see what happens. for example; SID_LIST_LISTENER = (SID_LIST = (SID_DESC = # (GLOBAL_DBNAME= x.world) (ORACLE_HOME= /oracle/product/8.1.7) (SID_NAME = ORCL) Joan Witold Iwaniec wrote: Hi DBAs I have a problem with database links in one of the databases - the name of the link gets us.oracle.com appended to it. create database link test connect to test_user identified by test_pwd using 'test_db' When I execute: select * from my_table@test I get the ORA-02085 error message the the link test.us.oracle.com connects to test. When I execute: select * from global_name; in the target database the result is: TEST but in the database where I created the link the database name has the suffix: NOVALIS.US.ORACLE.COM I have no problem with database links in the TEST database but would like to know which parameter causes the suffix to be appended in the NOVALIS database. In both init.ora files the global_names is set to true and db_domain is commented out. In both databases the command show parameters; returns the db_domain as blank. Actually both databases are on the same server - Oracle 8.1.6. What should I change to remove the US.ORACLE.COM suffix. I don't care too much about the database, it's my test only, but don't want it appended in the links and maybe other objects... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: Joan Hsieh 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: KSH Scripting Questions
Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 . . . Good Luck, John [EMAIL PROTECTED] 12/10/01 11:30AM Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson 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 Lange 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 Carlson 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 Lange 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).
Adding intermedia Text to 8.1.6 database
Hello Can someone point me to documentation how to add intermedia text to a database in Oracle 8.1.6 (on NT)? I installed interMedia and can use in the database created by the setup but would like to add it to another database on the same server. The documentation that I have found at OTN refers to running few scripts that are in %ORACLE_HOME%\ctx\admin. That's all clear but I don't have the ctx\lib directory and obviously the libctxx8.so file required to build data dictionary. The interMedia works in the default database - I can build index of type ctxsys.context, do text search so all the libraries must be installed. But search for file libct*.so on all my hard drives returns nothing. Something else must be used... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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 down
ipcs -a ipcrm - etc -Original Message- Sent: Monday, December 10, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: Mohan, Ross 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: Adding intermedia Text to 8.1.6 database
Hi all I have found my answer... I have seen other people asking on other forums so the answer may help someone some day... On NT the library is: %ORACLE_HOME%\bin\oractxx8.dll Witold Hello Can someone point me to documentation how to add intermedia text to a database in Oracle 8.1.6 (on NT)? I installed interMedia and can use in the database created by the setup but would like to add it to another database on the same server. The documentation that I have found at OTN refers to running few scripts that are in %ORACLE_HOME%\ctx\admin. That's all clear but I don't have the ctx\lib directory and obviously the libctxx8.so file required to build data dictionary. The interMedia works in the default database - I can build index of type ctxsys.context, do text search so all the libraries must be installed. But search for file libct*.so on all my hard drives returns nothing. Something else must be used... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: Witold Iwaniec 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 down
Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff [EMAIL PROTECTED] 12/10/01 02:27PM Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: Jeff Wiegard 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: KSH Scripting Questions
Topic done. Error found. Some idiot . who will remain nameless if he wants to continue typing this message echo'ed a space to the file after he tested to see if it had been deleted in the monitor program. SO, the main program was deleting the file ... and the montor was recreating it . Doh ... Just call me Homer ... After all ... I did just come from working at a Nuclear Plant -Original Message- Sent: Monday, December 10, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 . . . Good Luck, John [EMAIL PROTECTED] 12/10/01 11:30AM Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson 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 Lange 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 Carlson 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 Lange INET: [EMAIL PROTECTED] Fat City Network Services
RE: Database down
I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you? -Original Message- Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Preventing ORA-1403 in triggers
Thanks guys! I'm thinking that we're going to use the anonymous block local exception idea. Now if they would let me turn this mess into a materialized view, my question would be moot! Thanks again! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Hi, So a developer asks me How do I prevent ORA-1403 in my SELECT statement in my trigger? I thought this would be simple, but my brain's just not all here. The statement is simple: SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2 The problem is that we don't know if the user-entered indexcols exist. I could preface this statement with a SELECT count(*) INTO mycount... to see if there are existing rows, but I was hoping to do this all in one SQL statement if possible, especially if/when this scenarios will happen with non-indexed columns (don't ask). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 down
I discovered the trace file after restarting Oracle - so that process ID is no longer out there. I've also discovered that there is a specific patch for this problem, which appears not to have been applied. I will move forward with this, but would like to provide management with an explanation as to why we had problems now, after so many days of uptime. Thanks for your help. Jeff [EMAIL PROTECTED] 12/10/01 03:35PM I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you? -Original Message- Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Jeff Wiegard 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).
deleting large volumes of data
Dear listers! what would you suggest as the best method for delete from a large table where some rows have to disappear e.g. delete from a partitioned data warehouse table, where the delete transaction would not fit into a rollback segment ? method 1 What do you think of updating the partition key in order to move the unwanted rows to a special waste basket partition and then truncate this partition? method 2 how about the following code ? loop delete from T where some predicate AND rownum 1; exit when sql%rowcount = 0; commit; end loop; commit; ( source: http://asktom.oracle.com/pls/ask/f?p=4950:8:313997::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1261400453244 ) Thanks Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andreas Haunschmidt 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: KSH Scripting Questions
Which one? I want to make sure I'm not living near it ;) Now, where did my doughnut go... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: KSH Scripting Questions com 12/10/01 02:27 PM Please respond to ORACLE-L Topic done. Error found. Some idiot . who will remain nameless if he wants to continue typing this message echo'ed a space to the file after he tested to see if it had been deleted in the monitor program. SO, the main program was deleting the file ... and the montor was recreating it . Doh ... Just call me Homer ... After all ... I did just come from working at a Nuclear Plant -Original Message- Sent: Monday, December 10, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas 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 down
maybe a mild uptick in resource contention after adding a third app server passed over some internal threshold? shrug -Original Message- Sent: Monday, December 10, 2001 4:50 PM To: Multiple recipients of list ORACLE-L I discovered the trace file after restarting Oracle - so that process ID is no longer out there. I've also discovered that there is a specific patch for this problem, which appears not to have been applied. I will move forward with this, but would like to provide management with an explanation as to why we had problems now, after so many days of uptime. Thanks for your help. Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
shared memory error
Paula: This is pretty ugly. Let's at least see if we can get rid of the cartesian. Barb -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=293 Card=2587 Bytes= 724360) 10 SORT (UNIQUE) (Cost=293 Card=2587 Bytes=724360) 21 UNION-ALL 32 NESTED LOOPS (Cost=109 Card=1679 Bytes=470120) 43 NESTED LOOPS (Cost=14140 Card=1083 Bytes=251256) 54 HASH JOIN (Cost=60676 Card=282793 Bytes=53447877) 65 TABLE ACCESS (FULL) OF 'AD' (Cost=192 Card=62123 Bytes=6212300) 75 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 87 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 97 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 109 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 114 TABLE ACCESS (BY INDEX ROWID) OF 'CUSTOMER' (Cost=1 Card=412032 Bytes=17717376) 12 11 INDEX (UNIQUE SCAN) OF 'I_CUS1' (UNIQUE) 133 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=96304 Bytes=4622592) 14 13 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=96304) 152 NESTED LOOPS (Cost=76 Card=908 Bytes=254240) 16 15 NESTED LOOPS (Cost=218768391 Card=752 Bytes=174464) 17 16 MERGE JOIN (Cost=101449 Card=4375367808 Bytes=577548550656) 18 17 SORT (JOIN) (Cost=97464 Card=2771559 Bytes=246668751) 19 18 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 20 19 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 21 19 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 22 21 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 23 17 SORT (JOIN) (Cost=3985 Card=412032 Bytes=17717376) 24 23 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=945 Card=412032 Bytes=17717376) 25 16 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1 Card=525111 Bytes=52511100) 26 25 INDEX (UNIQUE SCAN) OF 'I_AD1' (UNIQUE) 27 15 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=633898 Bytes=30427104) 28 27 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=633898) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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).
IGNORE: shared memory error
Oops! Pasted to the wrong window. So sorry. Barb -- From: Baker, Barbara Sent: Monday, December 10, 2001 3:12 PM To: '[EMAIL PROTECTED]' Subject: shared memory error Paula: This is pretty ugly. Let's at least see if we can get rid of the cartesian. Barb -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=293 Card=2587 Bytes= 724360) 10 SORT (UNIQUE) (Cost=293 Card=2587 Bytes=724360) 21 UNION-ALL 32 NESTED LOOPS (Cost=109 Card=1679 Bytes=470120) 43 NESTED LOOPS (Cost=14140 Card=1083 Bytes=251256) 54 HASH JOIN (Cost=60676 Card=282793 Bytes=53447877) 65 TABLE ACCESS (FULL) OF 'AD' (Cost=192 Card=62123 Bytes=6212300) 75 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 87 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 97 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 109 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 114 TABLE ACCESS (BY INDEX ROWID) OF 'CUSTOMER' (Cost=1 Card=412032 Bytes=17717376) 12 11 INDEX (UNIQUE SCAN) OF 'I_CUS1' (UNIQUE) 133 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=96304 Bytes=4622592) 14 13 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=96304) 152 NESTED LOOPS (Cost=76 Card=908 Bytes=254240) 16 15 NESTED LOOPS (Cost=218768391 Card=752 Bytes=174464) 17 16 MERGE JOIN (Cost=101449 Card=4375367808 Bytes=577548550656) 18 17 SORT (JOIN) (Cost=97464 Card=2771559 Bytes=246668751) 19 18 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 20 19 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 21 19 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 22 21 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 23 17 SORT (JOIN) (Cost=3985 Card=412032 Bytes=17717376) 24 23 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=945 Card=412032 Bytes=17717376) 25 16 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1 Card=525111 Bytes=52511100) 26 25 INDEX (UNIQUE SCAN) OF 'I_AD1' (UNIQUE) 27 15 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=633898 Bytes=30427104) 28 27 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=633898) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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).
Help in deciphering the values for flag in systemstate dump
Title: Help in deciphering the values for flag in systemstate dump I'm troubleshooting a discrepancy between v$session_wait and Precise/SQL 3.1. Oracle reports that sessions waiting on SQL*Net message from client but the tool shows some of them in MTS wait. Since Precise/SQL parses the SGA for its data I'm looking into a systemstate dump. The only link I have found is that the circuit session object have flag = (10100) and flag = (10130). The circuits with 10130 are tied to the sessions that are misreported by the tool. While I'm waiting for tech. support to respond any nuggets you can provide will be greatly appreciated. Thanks. Tony Aponte Environment: Sun Solaris 8 Oracle 8.1.7.2 5/50 MTS dispatchers/servers Partial system state dump: PROCESS 62: SO: ceaef290, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00 (process) Oracle pid=62, calls cur/top: 0/d0aab070, flag: (40) DISPATCHER int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 0 0 118 last post received-location: kmcpdp last process to post me: ceae53fc 1 32 last post sent: 2147544044 0 111 last post sent-location: kmcmbf: not KMCVCFTOS last process posted by me: ceae53fc 1 32 (latch info) wait_event=0 bits=0 Process Group: DEFAULT, pseudo proc: ceba58e4 O/S info: user: oracle, term: UNKNOWN, ospid: 6500 OSD pid info: 6500 SO: d08991f4, type: 41, owner: ceaef290, pt: 0, flag: INIT/-/-/0x00 (circuit) dispatcher process id = (ceaef290, 1) parent process id = (62, 1) user session id = (152, 28431) connection context = 1a3c454 user session = (cebf98fc), flag = (10100), queue = (8) = The flag is on this line. current buffer = (1), status = (0, 0) SO: cebf98fc, type: 3, owner: d08991f4, pt: 0, flag: INIT/-/-/0x00 (session) trans: 0, creator: d08991f4, flag: (8e1) USR/- -/-/-/-/-/- DID: 0001-000B-0A09, short-term DID: -- txn branch: 0 oct: 0, prv: 0, user: 17178/CRUZDO O/S info: user: CRUZD, term: OMSCTX10, ospid: 4040:3800, machine: STPETE\OMSCTX10 program: siebel.exe waiting for 'SQL*Net message from client' blocking sess=0x0 seq=1017 wait_time=0 driver id=4d545300, #bytes=1, =0
RE: KSH Scripting Questions
It was down at Comanche Peak Nuclear Station just south of Ft. Worth Texas. -Original Message- Sent: Monday, December 10, 2001 3:58 PM To: Multiple recipients of list ORACLE-L Which one? I want to make sure I'm not living near it ;) Now, where did my doughnut go... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: KSH Scripting Questions com 12/10/01 02:27 PM Please respond to ORACLE-L Topic done. Error found. Some idiot . who will remain nameless if he wants to continue typing this message echo'ed a space to the file after he tested to see if it had been deleted in the monitor program. SO, the main program was deleting the file ... and the montor was recreating it . Doh ... Just call me Homer ... After all ... I did just come from working at a Nuclear Plant -Original Message- Sent: Monday, December 10, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas 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 Lange 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: IGNORE: shared memory error
don't let it happen again, BB, or it's the Caves for you. -Original Message- Oops! Pasted to the wrong window. So sorry. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: KSH Scripting Questions
Hey Homer, Was that you hawking the Uranium 235 on ebay? Jared Kevin Lange [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: KSH Scripting Questions [EMAIL PROTECTED] om 12/10/01 01:27 PM Please respond to ORACLE-L Topic done. Error found. Some idiot . who will remain nameless if he wants to continue typing this message echo'ed a space to the file after he tested to see if it had been deleted in the monitor program. SO, the main program was deleting the file ... and the montor was recreating it . Doh ... Just call me Homer ... After all ... I did just come from working at a Nuclear Plant -Original Message- Sent: Monday, December 10, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1 trap my_function 2 2 . . . Good Luck, John [EMAIL PROTECTED] 12/10/01 11:30AM Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main program ends before the monitor programs. What happens is , that when the main program ends, the monitor closes down because it was spawned by the main program. Because of this, no all the flag files are getting deleted. I need to know the proper trap to set and its syntax to catch an ending program so that I can get it to delete the flag files. Anyone have any ideas ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: shared memory error
Maybe you should enter it in Eric P.'s ugly SQL contest? Jared Baker, Barbara bbaker@denvernewspapera To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] gency.com cc: Sent by: Subject: shared memory error [EMAIL PROTECTED] 12/10/01 02:10 PM Please respond to ORACLE-L Paula: This is pretty ugly. Let's at least see if we can get rid of the cartesian. Barb -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=293 Card=2587 Bytes= 724360) 10 SORT (UNIQUE) (Cost=293 Card=2587 Bytes=724360) 21 UNION-ALL 32 NESTED LOOPS (Cost=109 Card=1679 Bytes=470120) 43 NESTED LOOPS (Cost=14140 Card=1083 Bytes=251256) 54 HASH JOIN (Cost=60676 Card=282793 Bytes=53447877) 65 TABLE ACCESS (FULL) OF 'AD' (Cost=192 Card=62123 Bytes=6212300) 75 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 87 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 97 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 109 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 114 TABLE ACCESS (BY INDEX ROWID) OF 'CUSTOMER' (Cost=1 Card=412032 Bytes=17717376) 12 11 INDEX (UNIQUE SCAN) OF 'I_CUS1' (UNIQUE) 133 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=96304 Bytes=4622592) 14 13 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=96304) 152 NESTED LOOPS (Cost=76 Card=908 Bytes=254240) 16 15 NESTED LOOPS (Cost=218768391 Card=752 Bytes=174464) 17 16 MERGE JOIN (Cost=101449 Card=4375367808 Bytes=577548550656) 18 17 SORT (JOIN) (Cost=97464 Card=2771559 Bytes=246668751) 19 18 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559 Bytes=246668751) 20 19 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1 Card=261 Bytes=8874) 21 19 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045) 22 21 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152 Card=10619 Bytes=584045) 23 17 SORT (JOIN) (Cost=3985 Card=412032 Bytes=17717376) 24 23 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=945 Card=412032 Bytes=17717376) 25 16 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1 Card=525111 Bytes=52511100) 26 25 INDEX (UNIQUE SCAN) OF 'I_AD1' (UNIQUE) 27 15 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=633898 Bytes=30427104) 28 27 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1 Card=633898) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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
RE: Cannot Drop Column
Apologies if this has already been mentioned. You will need a (free) technet account to access these links. Hope these links didn't wrap. HTH Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 You cannot drop all columns from a table, nor can you drop columns from a table owned by SYS. Any attempt to do so will result in an error. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76956/tables.htm#1451 Use your browser to search for the string: You cannot drop Oracle8i SQL Reference Release 3 (8.1.7) Part Number A85397-01 http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a85397/statem2a.htm#2055873 Use your browser to search the string: a table owned by SYS __ _ = -o)/ / (_)__ __ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional | _\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation | | Tel: (407) 859-7410 x2708 | = Supporter of the coalition for grumpiness where grumpiness is due -Original Message- Sent: Monday, December 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L I checked compatible in init.ora and it is set to 8.1.0. Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 12/07/01 02:25PM Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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,