PARAMETER SUBSTITUION ON UPDATE STATEMENT
Hi all, DECLARE mfield varchar2(20); CURSOR t1 Select region, value from table2; BEGIN FOR t1rec IN t1 LOOP mfield := t1rec.region||'_00'; UPDATE table1 SET mfield = mfield + 1; END LOOP; END; Basically, I would want to update field1 in table1 based on the value of region from table2. If region = ABC, I want to concatenate region and _00 to determine field to update in table1. Structure of Table1 REG_00 ABC_00 DES_00 Is this possible? Moses -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Send mail from pl/sql
Roland, Check out the Oracle supplied PL/SQL package UTL_SMTP: http://download-uk.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/utl_ smtp.htm HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 05 April 2002 08:33 To: Multiple recipients of list ORACLE-L Hallo, Does anyone have a good example on a procedure how to send email from Pl/SQL. What I want to happen is to do a select statement and then send a mail with the result to the address [EMAIL PROTECTED] Please help me with this. I would appreciate it very miuch. Thanks in advance Roland -- 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Automatically startup database
Had the same problem. Solved with SP2. Yechiel Adar, Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 1:49 PM Hi, I have try tro remove Microsoft Active Directory on Win2K and the database could run normallyautomatic startup.. where it did not run automatically when Microsoft Active Directory installed. I use SP1. Any suggestion? Thanks. Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, March 24, 2002 9:03 PM Hello Ferry There was a problem with the initial release of win 2K. Try to install a new service pack for windows. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Ferry Situmorang [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 6:38 PM To: Multiple recipients of list ORACLE-L Subject: Automatically startup database How to make database instance on Win2K automatically startup when the PC up? for now I have to run C: sqlplus internal sqlstartup ...every time myserver is powered on. TIA, Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ferry Situmorang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ang: RE: Send mail from pl/sql
I am using Notes mail system Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-05 01:18 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Which mail client are you looking it for. If it is for MS outlook, you can check at Perter Koltez's site Aleem -Original Message- Sent: Friday, April 05, 2002 12:33 PM To:Multiple recipients of list ORACLE-L Hallo, Does anyone have a good example on a procedure how to send email from Pl/SQL. What I want to happen is to do a select statement and then send a mail with the result to the address [EMAIL PROTECTED] Please help me with this. I would appreciate it very miuch. Thanks in advance Roland -- 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
run PL/SQL in background
We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send mail from pl/sql
send_email.sql send_email_attch.sql -Message d'origine- De: Abdul Aleem [mailto:[EMAIL PROTECTED]] Date: vendredi 5 avril 2002 11:18 À: Multiple recipients of list ORACLE-L Objet: RE: Send mail from pl/sql Which mail client are you looking it for. If it is for MS outlook, you can check at Perter Koltez's site Aleem -Original Message- Sent: Friday, April 05, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject:Send mail from pl/sql Hallo, Does anyone have a good example on a procedure how to send email from Pl/SQL. What I want to happen is to do a select statement and then send a mail with the result to the address [EMAIL PROTECTED] Please help me with this. I would appreciate it very miuch. Thanks in advance Roland -- 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). send_email.sql Description: Binary data send_email_attch.sql Description: Binary data
RE: PARAMETER SUBSTITUION ON UPDATE STATEMENT
You can use DBMS_SQL if it will help you. -Original Message- Moya Sent: 05 April 2002 15:28 To: Multiple recipients of list ORACLE-L Hi all, DECLARE mfield varchar2(20); CURSOR t1 Select region, value from table2; BEGIN FOR t1rec IN t1 LOOP mfield := t1rec.region||'_00'; UPDATE table1 SET mfield = mfield + 1; END LOOP; END; Basically, I would want to update field1 in table1 based on the value of region from table2. If region = ABC, I want to concatenate region and _00 to determine field to update in table1. Structure of Table1 REG_00 ABC_00 DES_00 Is this possible? Moses -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open resetlogs
Fawzia, This should be shown in your alert log. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Fawzia Sent: 05 April 2002 12:18 To: Multiple recipients of list ORACLE-L Hi, Does anyone know how to find out if the database was opened with the restlogsoption?We are having a few problems with rman and need to identify whether this has beent he case Thanks in advance Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
Give them root access and let them have at it!! Remember, it's a learning experience. Actually I have done this with my kids and I had then go on a tour with someone that knows that manufacturing facility, and then had them spend time in order entry, and the some time in the distribution center. They also had some time in the IS department but by showing them the whole facility they can see that what you do effects everything. They can only sit and watch you type for so long. Oh yea, I also let them spend some time with the PC techs and they got to fix some PC's. Dave -Original Message- Sent: Thursday, April 04, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-12514
Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Using XML in the dba
Bill, If you will be using the XML from PL/SQL calls, you will probably need the Oracle XDK for PL/SQL packages installed. There are several versions available. I actually installed the 9.0.2.0.0D version in my 8172 database and it seemed to work ok. The developer I was working with tried it, but dropped it for lack of time and interest. I created a separated Oracle account for the packages and installed the stuff there just so I could drop it easily. The packages are available on TechNet. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 5:56 PM To: Multiple recipients of list ORACLE-L I need to set up my 8.1.7.2 db to produce XML output from SQL queries. Referring to the Oracle XML Handbook (Oracle press) I think we're interesed in the XSQL . . . need to know how to prepare the db/client for this. I installed the JServer manually (via the initjvm.sql script) and have a 20Mb Java pool on the server (NT 40 SP6a) I see the client needs JDK 1.1.6 or higher. Is there anything else I need to do on the server? The developer will be accessing via Net8 (I think) . . . . not even sure what other questions I need to ask. Thanks, all Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: run PL/SQL in background
Possibly DBMS_AQ. What's wrong with DBMS_JOB? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 3:13 AM We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: run PL/SQL in background
Why don't you want to use dbms_job? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 5:13 AM We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Copy tables and indexes etc from one db to another
Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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: PARAMETER SUBSTITUION ON UPDATE STATEMENT
What is the relationship between table1 and table2? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 6:23 AM You can use DBMS_SQL if it will help you. -Original Message- Moya Sent: 05 April 2002 15:28 To: Multiple recipients of list ORACLE-L Hi all, DECLARE mfield varchar2(20); CURSOR t1 Select region, value from table2; BEGIN FOR t1rec IN t1 LOOP mfield := t1rec.region||'_00'; UPDATE table1 SET mfield = mfield + 1; END LOOP; END; Basically, I would want to update field1 in table1 based on the value of region from table2. If region = ABC, I want to concatenate region and _00 to determine field to update in table1. Structure of Table1 REG_00 ABC_00 DES_00 Is this possible? Moses -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-27072/HP-UX file too large
check kernel params. also try to create a large file not using oracle, see if it fails. i have seen i/o errors w/ autoextend on, just a thought. [EMAIL PROTECTED] 04/04/02 06:57PM Large file support is the first thing I checked (I should have put that in my post). It's enabled on all volumes. --- Gene Sais [EMAIL PROTECTED] wrote: its an os problem, make sure your filesystems are large enabled. aix has a 64gb filesize limit, forgot what hp ux is. [EMAIL PROTECTED] 04/04/02 11:23AM Hi, all. Oracle 8.1.7.2.0 on HP-UX B.11.00. When performing a full database export, I'm getting EXP-8: ORACLE error 1114 encountered ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error HP-UX Error: 27: File too large Additional information: 366985 ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error HP-UX Error: 27: File too large Additional information: 366985 EXP-0: Export terminated unsuccessfully File 201 is a tempfile, for the temporary tablespace. Its size is approx. 3 GB. A similar full export runs nightly and succeeded last night (I can't be sure about all previous nights as they don't save the log files). Has anyone else seen this? Why is export writing to the temporary tablespace? TIA = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle-SQL Server DBA Needed in Missouri..
A well established company located in Joplin,Missouri is looking for an ORACLE-SQL Server DBA. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: This position will be responsible for upgrading database and making conversion from ORACLE to SQL Server 2000. The person in this position will need to be very technical. The conversion will involve the HR and Financial databases. Once the conversion from Oracle 8 to SQL Server 2000 is done, this person will be maintaining their HR and Financials database on SQL Server 2000. They will still have their customer info. systems, engineering mapping systems, and outage management system on Oracle 8. So, that's why candidates need a background in Oracle and SQL Server DBA. Requirements: -A BS degree in CS is a plus, but will look at equivalent experience. -Must have at least 2 years experience with the following skills: ORACLE 8.0.4; SQL Server 7.0; DBA; Win-NT. -Needs to have had prior conversion and upgrade experience,preferably ORACLE to SQL Server. -Experience with SQL Server 2000 and Peoplesoft is a big plus. -U.S. citzenship or Permanent residents only. The company provides a base salary of 50-60K and excellent benefits. Some of them are as follows: low-cost healthcare; non-contributory pension; matching 401K; and FLEX benefits (i.e.dental and childcare). Joplin, MO is an excellent place to call home with a population of 50,000, and a trade area of 200,000. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Joplin/Oracle/SQL Server DBA/Ryan All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: run PL/SQL in background
John, A PL/SQL procedure run from dbms_job doesn't run continually - it is regularly restarted, which is quite different. The problem with continually running processes, PL/SQL or others, is that they have an innate tendency to take the CPU and not release it. If you want your solution to be viable, you need the process to block on something to give a chance to the other, competing processes - or you put it in polling mode (there's a kind of SLEEP function in one of the supplied packages, cannot remember which), or (what I'd prefer) you make it regularly wait on a DBMS_PIPE.RECEIVE or a DBMS_ALERT.WAITxxx, with or without a timeout shorter than your life expectancy. Now, for starting such a process, if you use DBMS_JOB it means that you will 'sacrifice', so to speak, a job process which will not be able to do anything else. It can be an acceptable solution if you increase job_processes accordingly. Or you can have the procedure called by SQL*Plus conveniently wrapped into an OS sc! ! ript, and make the OS script a detached process. HTH S Faroult - Original Message - From: John Dunn [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 05 Apr 2002 02:13:32 We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deleting old archive log files.
Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Using XML in the dba
thanks - don't need from PL/SQL, just regular SQL calls that will return tagged XML -Original Message- Sent: Fri, April 05, 2002 8:05 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Bill, If you will be using the XML from PL/SQL calls, you will probably need the Oracle XDK for PL/SQL packages installed. There are several versions available. I actually installed the 9.0.2.0.0D version in my 8172 database and it seemed to work ok. The developer I was working with tried it, but dropped it for lack of time and interest. I created a separated Oracle account for the packages and installed the stuff there just so I could drop it easily. The packages are available on TechNet. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 5:56 PM To: Multiple recipients of list ORACLE-L I need to set up my 8.1.7.2 db to produce XML output from SQL queries. Referring to the Oracle XML Handbook (Oracle press) I think we're interesed in the XSQL . . . need to know how to prepare the db/client for this. I installed the JServer manually (via the initjvm.sql script) and have a 20Mb Java pool on the server (NT 40 SP6a) I see the client needs JDK 1.1.6 or higher. Is there anything else I need to do on the server? The developer will be accessing via Net8 (I think) . . . . not even sure what other questions I need to ask. Thanks, all Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Copy tables and indexes etc from one db to another
export/import Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:18 AM Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: WHICH UNIX FOR ORACLE?
This is great information Raj. I've run a test that is completely consistent with this. For instance: Go to Metalink and click the Patches item in the left menu. Then choose product family Oracle Server and product RDBMS Server, release 9.0.1.3. Select the HP9000 Series HP/UX 64-bit platform and choose All Product Patches. Repeat for Sun Sparc Solaris. Although the Sun list is quite lengthy compared to most other platforms (7 entries), the HP list has significantly more patches (15 entries). For me, this is a significant decision influencer when choosing a platform for Oracle. However, HP is definitely losing the performance race... :-) Tough one. Thanks again, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 2:32 PM Paul , ORACLE switched from solaris to HP-UX somewhere in mid 2000 for their tier I platform. ALso I think at this time compaq and HP are the only true 64 bit architectures available. That of course swings the scale in HPs favour...:) Cheers, RS --- Paul Vallee [EMAIL PROTECTED] wrote: Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the equation for now. If you like NUMA, then look into the status of IBM's acquisition of Sequent, I'm out of touch with that right now.) Different hardware solutions from different vendors have different performance, stability and cost characteristics, and so I'll assume that all vendors have an appropriate solution on these factors, this may not be the case. With these assumptions, the primary factor for me is the timeliness of the availability of releases, patches and patchsets. Sun Solaris 32-bit is the winner on this factor on the grounds that it is Oracle's internal development platform. All other platforms are ported from Sun Solaris 32-bit. When that changes, my recommendation would of course also change, as it did when Oracle moved away from Digital/VMS. Anyone who has been in a situation where a bug was causing service failure and who heard that a patch was available for Solaris but not your platform knows where I'm coming from on this one. Note: for the exact same reason, never use 64-bit Oracle on Solaris unless you absolutely need the very-large-sga support. 64-bit Oracle on Solaris is slow to get patches and releases. Best, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:48 PM What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies to tell about the bugs and quality of support from SUN. Again this is only my opinion and as everybody knows OS is ,to some extent ,a matter of personal choice also. ( Running to put on flame proof suit..:) ) Cheers, RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: run PL/SQL in background
Agree! what is wrong with dbms_job? -Original Message- Sent: Friday, April 05, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Possibly DBMS_AQ. What's wrong with DBMS_JOB? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 3:13 AM We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN
It does. Damn thing installs automaagically in 8.1.7 if you are not paying really close attention. We caught it in the 9i install though. -Original Message- Sent: Thursday, April 04, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Steve, Good thought but I can not find any reference to Legato on the 8i for Linux disks. I did find reference to a readmelsm.doc in the index on the 8i for Nt disk but I could not find the file or the software. Think I will try the web for Legato for linux. Ron [EMAIL PROTECTED] 04/04/02 02:08PM I once used the scaled down version of Legato that came for free with Oracle and configured it without any problem. I used the tape drive on the DB server. Does Legato still come with 8i or 9i? -Original Message- Sent: Thursday, April 04, 2002 11:49 AM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Off topic: Need ideas for 'Take your child to work' day 4/25
[EMAIL PROTECTED] wrote: Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara can you create a test db? if you've got the space on a test server it would be ideal. have them do the typing, and explain what each parameter is for and what it does. then have them sign on and run catalog and catproc and watch all the stuff stream by. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Murphy's Third Law: In any field of scientific endeavor, anything that can go wrong will go wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off topic: Need ideas for 'Take your child to work' day 4/25
Yeah, and create a tablespace, with datafile - then create a table in that tablespace (with PK etc.) and create an index for the PK and any other fields that would warrant an index.. -Original Message- Sent: 05 April 2002 15:18 To: Multiple recipients of list ORACLE-L 4/25 [EMAIL PROTECTED] wrote: Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara can you create a test db? if you've got the space on a test server it would be ideal. have them do the typing, and explain what each parameter is for and what it does. then have them sign on and run catalog and catproc and watch all the stuff stream by. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Murphy's Third Law: In any field of scientific endeavor, anything that can go wrong will go wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about pl/sql code
Looks like the variable borttags_flagg, set in: OPEN c_t_PrisSubstitut FOR lvSQL; FETCH c_t_PrisSubstitut into tmpSubstitutPris,borttags_flagg,ButikPantBelopp; --tmpsubstitutean,tmpSubstitutVarutyp; CLOSE c_t_PrisSubstitut; is set to NULL? Cheers, John Thomas -Original Message- Sent: 05 April 2002 14:53 To: Multiple recipients of list ORACLE-L Hallo, I need some help on this. I woiuld like to include the field borttags_flagg in the table prisregister_kopia_wed but it fails and no records are inserted. In the eror table it says: Missing expression and the bad sql statement says INSERT INTO PBK.PRISREGISTER_kopia_wed(BUTIKID,EAN,PERIOD,LAGSTAPRIS,PRIS,UNDERLAGID,SUB STITUT,KOMMENTAR,BUTIKTYP,VARUTYP,REGICASTATUS,VARENR,LEVNR,VARE_SNR,BORTTAG S_FLAGG) VALUES (116,7312300342180,'200206', 0,9.95,616,NULL,'null', 0 , 0, 1, 290799, 13173, 10, ) The pl/sql code is this file. (See attached file: procinsert.txt) Here it is a missing value it should be a value after the last value 10. Why doesnt the value for borttags_flagg get included when inserted in that table. Would really appreciate help. Thanks in advance Roland ** Legal Disclaimer : This e-mail is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. The opinions expressed in this message are those of the sender and not those of TelesensKSCL. This footnote also confirms that this e-mail has been swept by MIMEsweeper for the presence of computer viruses. Please note that TelesensKSCL monitors both incoming and outgoing emails in accordance with our email policy. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: WHICH UNIX FOR ORACLE?
Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Seeking opinions
What happens when you run out of disk space on a mount point? It happened to me. I created a new datafile on another mount point, and then had to hear staff DBAs whining, why is there a rollback segment tablespace file on /u004?, as though it was a major disaster. Really, when people get into this mindset of file A MUST be in directory B, they lose all sight of what they should be doing (ensuring a smoothly running database) and concentrate more on whether every file is in the right place so that they don't have to query the data dictionary. OK, I feel better now. :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: I had an SA teach me that one, and it's saved me from making a REALLY stupid mistake a number of times. As for your client's standards, I can see why they want to impose standards and that's a good thing. But they are a bit too rigid with it, as others have said, what happens if you run out of disk space on a mount point? I probably have bored most of the people on this list to death with this, but I still believe that the ONLY way to make sure if a datafile is part of the database is to query the database. All you need is one forgetful person who misplaces or misnames a file. Rachel --- Paul Baumgartel [EMAIL PROTECTED] wrote: That's a great idea. Henceforth I'm going to do the same! Thanks. --- Rachel Carmichael [EMAIL PROTECTED] wrote: and, on a Unix box, I ALWAYS do an fuser before deleting a file. Just in case. --- Jonathan Gennick [EMAIL PROTECTED] wrote: On Tue, 02 Apr 2002 07:43:34 -0800, you wrote: Great point. I had recently created a DB file and forgot to put the .dbf extension on it. If someone didn't query the DD of the DB first, they might have thought it was a junk/temp file (they would have to ignore the file's timestamp) and deleted it. Yeah, naming convention or no, I can't imagine not looking at v$datafile or dba_datafiles just to be sure. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: ORA-27072/HP-UX file too large
How about ulimit. This looks like ulimit problem. Check metalink Note:1067314.6 on this issue. HTH Cheers, RS --- Paul Baumgartel [EMAIL PROTECTED] wrote: Large file support is the first thing I checked (I should have put that in my post). It's enabled on all volumes. --- Gene Sais [EMAIL PROTECTED] wrote: its an os problem, make sure your filesystems are large enabled. aix has a 64gb filesize limit, forgot what hp ux is. [EMAIL PROTECTED] 04/04/02 11:23AM Hi, all. Oracle 8.1.7.2.0 on HP-UX B.11.00. When performing a full database export, I'm getting EXP-8: ORACLE error 1114 encountered ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error HP-UX Error: 27: File too large Additional information: 366985 ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error HP-UX Error: 27: File too large Additional information: 366985 EXP-0: Export terminated unsuccessfully File 201 is a tempfile, for the temporary tablespace. Its size is approx. 3 GB. A similar full export runs nightly and succeeded last night (I can't be sure about all previous nights as they don't save the log files). Has anyone else seen this? Why is export writing to the temporary tablespace? TIA = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open resetlogs
If you go into rman with any target and at the rman prompt do; list incarnation of database; you will get a list of all of the databases in the recovery catalog and which one is current and the resetlogs information. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 6:18 AM Hi, Does anyone know how to find out if the database was opened with the restlogsoption?We are having a few problems with rman and need to identify whether this has beent he case Thanks in advance Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deleting old archive log files.
Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copy tables and indexes etc from one db to another
if the tables/indexes can be in self-contained tablespaces, check out the Transportable Tablespace option -bill -Original Message- Sent: Fri, April 05, 2002 8:59 AM To: Multiple recipients of list ORACLE-L export/import --- [EMAIL PROTECTED] wrote: Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Copy tables and indexes etc from one db to another
Roland, That all depends is a valid answer. If the tables are small and few a full export/import count be quick if the table are not created on the new server. If the tables are large you might run into the file size limitation of the OS and then an insert/select across a database link might be the answer. If the tables are large you might want to do an export with the select option to get portions of the data at a time. If the databases are remotely located a copy across the database link could be faster than an export, copy to tape, mail the tape, copy from tape, and import the data. With no specific information given you will get no specific answers. Generally an export/import is the fastest to move data from one location to another. ROR mª¿ªm [EMAIL PROTECTED] 04/05/02 08:18AM Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-12514
Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and
RE: DB Trigger to keep record of DDL
Thanks Jesse and Stphane. This script works, and is more elegant than my workaround. Tks. Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 5:28 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:RE: DB Trigger to keep record of DDL It's your SELECT that's causing the ORA-1422. If you're using 8i or 9i, you can avoid the SELECT and use the SYS_CONTEXT function like this: CREATE OR REPLACE TRIGGER CONTROL_DDL BEFORE DDL ON DATABASE BEGIN INSERT INTO CONTROL_OBJETOS (USUARIO, BASE_DATOS, HORA, OPERACION, ESQUEMA,TIPO_OBJETO, OBJETO, MAQUINA, USUARIO_OS) VALUES (ORA_LOGIN_USER,ORA_DATABASE_NAME, SYSDATE,ORA_SYSEVENT, ORA_DICT_OBJ_OWNER, ORA_DICT_OBJ_TYPE, ORA_DICT_OBJ_NAME, SYS_CONTEXT('USERENV','TERMINAL'), SYS_CONTEXT('USERENV','OS_USER')); END; (Note: I didn't test this code) HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: DB Trigger to keep record of DDL I did that trigger, it works if the only is logged in just once. It gives me the errors of more rows returned 1422. How can I know in what session he is. CREATE OR REPLACE TRIGGER CONTROL_DDL BEFORE DDL ON DATABASE DECLARE NOMBRE_MAQUINA VARCHAR2(20); USUARIO_MAQUINAVARCHAR2(20); BEGIN SELECT MACHINE, OSUSER INTO NOMBRE_MAQUINA, USUARIO_MAQUINA FROM V$SESSION WHERE USERNAME = ORA_LOGIN_USER; INSERT INTO CONTROL_OBJETOS (USUARIO, BASE_DATOS, HORA, OPERACION, ESQUEMA, TIPO_OBJETO, OBJETO, MAQUINA, USUARIO_OS) VALUES (ORA_LOGIN_USER, ORA_DATABASE_NAME, SYSDATE,ORA_SYSEVENT, ORA_DICT_OBJ_OWNER, ORA_DICT_OBJ_TYPE, ORA_DICT_OBJ_NAME, NOMBRE_MAQUINA, USUARIO_MAQUINA); END; TIA Ramon E. Estevez -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Copy tables and indexes etc from one db to another
Roland, I have a theory..., never mind. (Heavy sigh). Have you ever heard of a thing called a db link? Please try looking that up. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Copy tables and indexes etc from one db to another om 04/05/2002 07:18 AM Please respond to ORACLE-L Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send mail from pl/sql
Two questions: 1) Why should the client matter? 2) What is the web address of the site you mention? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Abdul Aleem [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 3:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Send mail from pl/sql Which mail client are you looking it for. If it is for MS outlook, you can check at Perter Koltez's site Aleem -Original Message- Sent: Friday, April 05, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: Send mail from pl/sql Hallo, Does anyone have a good example on a procedure how to send email from Pl/SQL. What I want to happen is to do a select statement and then send a mail with the result to the address [EMAIL PROTECTED] Please help me with this. I would appreciate it very miuch. Thanks in advance Roland -- 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).
parallel sql*load and extents
Hi all. I apologise if it is a duplicate post. I didn't see this message on the list so I'm trying again. We have a table with initial set to 32K and next set to 1M. This table is being loaded daily via a SQL*Loader in parallel mode (8 way) with direct=true. When I look at this table in the dba_Segments I see that all the new extents are 16K and looks like many of them are empty. I read a few documents regarding sql*loader in parallel direct mode, but I'm still confused as to why are these extents are all 16K instead of being 32K (some) and 1M (most). Also why do I see unused blocks ? thank you Gene __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WHICH UNIX FOR ORACLE?
Yes, let's not miss an opportunity to remind Evil Bill of his contribution to the wonderful world of UNIX. Xenix/286... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Boivin, Patrice J Sent: 04 April 2002 21:09 To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? How about XENIX? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 04, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP, it was Windows. Who cares that it's not as stable as I would like. You should have seen the VP grin at me with this patronizing smile when he said, I'll approve $35,000 for this project!, like he had done me a huge favor. I wanted to growl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unistall Oracle
Hi list, How can I Uninstall Oracle from sun OS 5.7, THX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deferred constraints
Hello, Env: 8.1.6.0.0 on Solaris 2.7 From reading the docs regarding constraint states, it sounds like there is no difference in constraint behaviour between a constraint created as not deferred vs a constraint created as deferred and initially immediate. Is this correct? The only difference I can see is that a constraint created as deferred can subsequently be altered to other constraint states, whereas a constraint created as not deferred cannot. If the above is correct, is it a good practice to make the default for constraint creation deferred and initially immediate? The justification for this would be the flexibility of altering the constraint state, should the need ever arise. How do most of you create your constraints, as deferred or not deferred? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WHICH UNIX FOR ORACLE?
Paul, I am glad you are on your way to 'controlled molecular restructuring and HP-iozation' (??!) ..;) Mind telling me What made you say HP's is losing performance race..? I am on HP mid level (N class) 4 way server 64 bit and our Database is 210 Gigs High end OLTP database with 12 TPS and severe response time restrictions(1 sec or less.) I am beating the response time by several milliseconds and I haven't even maxed out the processors yet...!! HTH Cheers, RS --- Paul Vallee [EMAIL PROTECTED] wrote: This is great information Raj. I've run a test that is completely consistent with this. For instance: Go to Metalink and click the Patches item in the left menu. Then choose product family Oracle Server and product RDBMS Server, release 9.0.1.3. Select the HP9000 Series HP/UX 64-bit platform and choose All Product Patches. Repeat for Sun Sparc Solaris. Although the Sun list is quite lengthy compared to most other platforms (7 entries), the HP list has significantly more patches (15 entries). For me, this is a significant decision influencer when choosing a platform for Oracle. However, HP is definitely losing the performance race... :-) Tough one. Thanks again, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 2:32 PM Paul , ORACLE switched from solaris to HP-UX somewhere in mid 2000 for their tier I platform. ALso I think at this time compaq and HP are the only true 64 bit architectures available. That of course swings the scale in HPs favour...:) Cheers, RS --- Paul Vallee [EMAIL PROTECTED] wrote: Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the equation for now. If you like NUMA, then look into the status of IBM's acquisition of Sequent, I'm out of touch with that right now.) Different hardware solutions from different vendors have different performance, stability and cost characteristics, and so I'll assume that all vendors have an appropriate solution on these factors, this may not be the case. With these assumptions, the primary factor for me is the timeliness of the availability of releases, patches and patchsets. Sun Solaris 32-bit is the winner on this factor on the grounds that it is Oracle's internal development platform. All other platforms are ported from Sun Solaris 32-bit. When that changes, my recommendation would of course also change, as it did when Oracle moved away from Digital/VMS. Anyone who has been in a situation where a bug was causing service failure and who heard that a patch was available for Solaris but not your platform knows where I'm coming from on this one. Note: for the exact same reason, never use 64-bit Oracle on Solaris unless you absolutely need the very-large-sga support. 64-bit Oracle on Solaris is slow to get patches and releases. Best, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:48 PM What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies to tell about the bugs and quality of support from SUN. Again this is only my opinion and as everybody knows OS is ,to some extent ,a matter of personal choice also. ( Running to put on flame proof suit..:) ) Cheers, RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ --
RE: Re[2]: WHICH UNIX FOR ORACLE?
My experiance is just the opposite : 1. Solaris 2. Solaris 3. Solaris 4. HP-UX 5. AIX 6. Digital Unix 7. SCO Unix Solaris has much better features and is more reliable as per my experience. For eg. only Solaris provides the option to use Asynchronous I/O for file systems as well as raw devices. Asynchronous I/O on HP will b used only while accessing raw devices. I think that the Oracle software is primarily written on Solaris these days. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 April 2002 15:08 To: Multiple recipients of list ORACLE-L Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). ___ 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
RE: run PL/SQL in background
It can be an acceptable solution if you increase job_processes accordingly. Yes, the developers approach is to have these processes sleep using dbms_lock. My main concern with starting these via dbms_jobs is that if the number of such long running PL/SQL procedures grows, so will the number of job_processes. I am vary of having too many ora_snp processes running since presumably they use system resources in their own right? John -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: 05 April 2002 14:18 To: Multiple recipients of list ORACLE-L Subject: RE: run PL/SQL in background John, A PL/SQL procedure run from dbms_job doesn't run continually - it is regularly restarted, which is quite different. The problem with continually running processes, PL/SQL or others, is that they have an innate tendency to take the CPU and not release it. If you want your solution to be viable, you need the process to block on something to give a chance to the other, competing processes - or you put it in polling mode (there's a kind of SLEEP function in one of the supplied packages, cannot remember which), or (what I'd prefer) you make it regularly wait on a DBMS_PIPE.RECEIVE or a DBMS_ALERT.WAITxxx, with or without a timeout shorter than your life expectancy. Now, for starting such a process, if you use DBMS_JOB it means that you will 'sacrifice', so to speak, a job process which will not be able to do anything else. It can be an acceptable solution if you increase job_processes accordingly. Or you can have the procedure called by SQL*Plus conveniently wrapped into an OS sc! ! ript, and make the OS script a detached process. HTH S Faroult - Original Message - From: John Dunn [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 05 Apr 2002 02:13:32 We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Audit DB
Hi List, Is there any article that describe the pros and cons about activating the audit options in a Database. In oracle class manuals and Oracle 8i Administrator Guide, there is not enough information about that topic. What I have read and heard is that DB Audit should be the last option due to the amount of information that gathers. I would like something more detailed about this. Tks Ramon -- 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: Off topic: Need ideas for 'Take your child to work' day 4/25
Give them root access and let them have at it!! No... Just give them OEM and let them point and click to their hearts desire so they can be just as dangerous as a real JUNIOR DBA. -Original Message- Sent: Friday, April 05, 2002 5:08 AM To: Multiple recipients of list ORACLE-L 4/25 Give them root access and let them have at it!! Remember, it's a learning experience. Actually I have done this with my kids and I had then go on a tour with someone that knows that manufacturing facility, and then had them spend time in order entry, and the some time in the distribution center. They also had some time in the IS department but by showing them the whole facility they can see that what you do effects everything. They can only sit and watch you type for so long. Oh yea, I also let them spend some time with the PC techs and they got to fix some PC's. Dave -Original Message- Sent: Thursday, April 04, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i 1Z0-007 Exam
Has anyone taken this test? If so I would like your feedback. Thanks, Ken Janusz, CPIM
Re: Unistall Oracle
man rm On Fri, Apr 05, 2002 at 07:23:32AM -0800, Hamid Alavi wrote: Hi list, How can I Uninstall Oracle from sun OS 5.7, THX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Favourite Urban Myth
That depends on how much system level work the DBA has to do. If the SA's are good and understand Oracle RDBMS system requirements then no the DBA can do without root. They do need access to the Oracle related file systems, /tmp, and the application filesystems. Rodd On Thu, 2002-04-04 at 10:18, Dave Morgan wrote: The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seeking opinions
I'm not disagreeing with you - that's my point in saying look inside the database! --- Paul Baumgartel [EMAIL PROTECTED] wrote: What happens when you run out of disk space on a mount point? It happened to me. I created a new datafile on another mount point, and then had to hear staff DBAs whining, why is there a rollback segment tablespace file on /u004?, as though it was a major disaster. Really, when people get into this mindset of file A MUST be in directory B, they lose all sight of what they should be doing (ensuring a smoothly running database) and concentrate more on whether every file is in the right place so that they don't have to query the data dictionary. OK, I feel better now. :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: I had an SA teach me that one, and it's saved me from making a REALLY stupid mistake a number of times. As for your client's standards, I can see why they want to impose standards and that's a good thing. But they are a bit too rigid with it, as others have said, what happens if you run out of disk space on a mount point? I probably have bored most of the people on this list to death with this, but I still believe that the ONLY way to make sure if a datafile is part of the database is to query the database. All you need is one forgetful person who misplaces or misnames a file. Rachel --- Paul Baumgartel [EMAIL PROTECTED] wrote: That's a great idea. Henceforth I'm going to do the same! Thanks. --- Rachel Carmichael [EMAIL PROTECTED] wrote: and, on a Unix box, I ALWAYS do an fuser before deleting a file. Just in case. --- Jonathan Gennick [EMAIL PROTECTED] wrote: On Tue, 02 Apr 2002 07:43:34 -0800, you wrote: Great point. I had recently created a DB file and forgot to put the .dbf extension on it. If someone didn't query the DD of the DB first, they might have thought it was a junk/temp file (they would have to ignore the file's timestamp) and deleted it. Yeah, naming convention or no, I can't imagine not looking at v$datafile or dba_datafiles just to be sure. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do
RE: WHICH UNIX FOR ORACLE?
Lot's of listers have presented nice lists but if you don't have Linux on your list then your experience is woefully incomplete. Long live Linux! The war is on and those who don't join this camp soon will find themselves on the losing side! :-) I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful. Unopinionatedly yours, Archie Bunker Steve Orr -Original Message- Sent: Friday, April 05, 2002 8:34 AM To: Multiple recipients of list ORACLE-L My experiance is just the opposite : 1. Solaris 2. Solaris 3. Solaris 4. HP-UX 5. AIX 6. Digital Unix 7. SCO Unix Solaris has much better features and is more reliable as per my experience. For eg. only Solaris provides the option to use Asynchronous I/O for file systems as well as raw devices. Asynchronous I/O on HP will b used only while accessing raw devices. I think that the Oracle software is primarily written on Solaris these days. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 April 2002 15:08 To: Multiple recipients of list ORACLE-L Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bought a Coriolis book at 75% off, how safe is my cust info?
On their web site it's 75% off so I finally bought the black book. Now I had to supply my email, credit card #, home address. Since they'll be selling off everything including customer info (I assume), how safe was it, just to save $30 on the book?
RE: run PL/SQL in background
Any job requires a process and process is a process...it does not matter if it's snp a process or a shadow process. -Original Message- Sent: Friday, April 05, 2002 11:04 AM To: Multiple recipients of list ORACLE-L It can be an acceptable solution if you increase job_processes accordingly. Yes, the developers approach is to have these processes sleep using dbms_lock. My main concern with starting these via dbms_jobs is that if the number of such long running PL/SQL procedures grows, so will the number of job_processes. I am vary of having too many ora_snp processes running since presumably they use system resources in their own right? John -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: 05 April 2002 14:18 To: Multiple recipients of list ORACLE-L Subject: RE: run PL/SQL in background John, A PL/SQL procedure run from dbms_job doesn't run continually - it is regularly restarted, which is quite different. The problem with continually running processes, PL/SQL or others, is that they have an innate tendency to take the CPU and not release it. If you want your solution to be viable, you need the process to block on something to give a chance to the other, competing processes - or you put it in polling mode (there's a kind of SLEEP function in one of the supplied packages, cannot remember which), or (what I'd prefer) you make it regularly wait on a DBMS_PIPE.RECEIVE or a DBMS_ALERT.WAITxxx, with or without a timeout shorter than your life expectancy. Now, for starting such a process, if you use DBMS_JOB it means that you will 'sacrifice', so to speak, a job process which will not be able to do anything else. It can be an acceptable solution if you increase job_processes accordingly. Or you can have the procedure called by SQL*Plus conveniently wrapped into an OS sc! ! ript, and make the OS script a detached process. HTH S Faroult - Original Message - From: John Dunn [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 05 Apr 2002 02:13:32 We have a package that we want to run effectively in the background/batch mode, i.e detached from the pl/sql that initates it. Basically the package would run continually until a table value tells it to stop. Is there an alternative to using dbms_job? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: WHICH UNIX FOR ORACLE?
Dick, I agree completely with your #1. We run on all of these platforms here (the Linux is running off my desktop). I have not had any Oracle support calls on the AIX system, but it is a very lightly used db. IBM's hw support response is awesome though. I put it above HP's which is pretty good for our area. (Location caveat: I am in Sioux Falls, SD - ANY call will most likely be a minimum of 4HRS wait probably 8 depending on the vendor). I haven't dealt with Sun support here. As mentioned in other posts, I am my support for Linux. We met with Oracle and HP reps back in 2001. They did confirm that HP is the development platform for Oracle, and that 64bit is being worked on both the PA-RISC and IA64 processors on HP. So... 1. HP 2. AIX (fast hw support in the boonies is cool) 3. Sun (Have fits with ksh on Sun it doesn't work the same as the other two) 4. Linux (May move up if had 3rd party 7X24 support available) Rodd Holman On Thu, 2002-04-04 at 14:08, [EMAIL PROTECTED] wrote: Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Unistall Oracle
Hamid, The safest way to uninstall Oracle is the same way it was installed. Use the installer software and then choose the uninstall option for the selected items. Place to Oracle disk in the CDROM and follow the onscreen instructions if it is a GUI install. ROR mª¿ªm [EMAIL PROTECTED] 04/05/02 10:23AM Hi list, How can I Uninstall Oracle from sun OS 5.7, THX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Audit DB
Ramon - Perhaps you could tell us what you are trying to accomplish with autiting. I haven't used it myself, but the amount of information will depend on how much auditing you turn on. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 05, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hi List, Is there any article that describe the pros and cons about activating the audit options in a Database. In oracle class manuals and Oracle 8i Administrator Guide, there is not enough information about that topic. What I have read and heard is that DB Audit should be the last option due to the amount of information that gathers. I would like something more detailed about this. Tks Ramon -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Moving From Rule-Based to Cost-Based
Hello All, At our site, we are use rule based optimization. We are careful to write SQL that performs well under this mode. Some of our SQL also contains hints. When we provide our application to clients, we default it to use Rule-based. However, some clients may choose to run our application in cost-based mode. This will be as simple as analyzing all tables and indexes in our schemas', and changing the mode to use cost based. My Questions: 1. How likely is it that our application will perform worse under cost-based than it does under rule-based. What has been the experience of others on the list who have moved from Rule-based to Cost-based? 2. What are some of the underlying reasons for performance to decline when making such a move? What are some gotchas to watch for? 3. Is there more that needs to be done to move from rule to cost? (Other than changing the optimization mode and analyzing tables and indexes)? Most clients run our database on NT, although some use UNIX. Assume Oracle 9i. Our database (at client sites) tends to be small, with the largest being about 25 GB. Thanks for any suggestions, Sam Bootsma Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connecting to Oracle via Perl
On Wednesday 03 April 2002 06:53, Koivu, Lisa wrote: * Anytime I connect to sql*plus (I don't do it with DBI) I use the system call and refer to the parameter value in the hash within my connect string: $$parms_ref{'elvis_pw'}. I don't use DBI because my calls are to fire stored procedures, and if I remember right the DBI doesn't support calling stored procs. Please correct me if I'm wrong. Ok, you're wrong. :) Check out the DBD::Oracle docs, stored procedures definitely work. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Entry Level Pay Question
Hi folks, Can anyone give me a general idea of entry level (junior) Oracle DBA (certified) in the Los Angeles area? Thanks! --JoJo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deleting old archive log files.
Years of Perl evangelism are finally paying off. :) Jared On Friday 05 April 2002 07:18, Igor Neyman wrote: Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WHICH UNIX FOR ORACLE?
As Steve's bunkermate I'll second the Linux thing. We're having good luck with Linux here. I've done AIX and Solaris, and Linux is up there with'em. --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, April 05, 2002 9:31 AM To: Multiple recipients of list ORACLE-L Lot's of listers have presented nice lists but if you don't have Linux on your list then your experience is woefully incomplete. Long live Linux! The war is on and those who don't join this camp soon will find themselves on the losing side! :-) I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful. Unopinionatedly yours, Archie Bunker Steve Orr -Original Message- Sent: Friday, April 05, 2002 8:34 AM To: Multiple recipients of list ORACLE-L My experiance is just the opposite : 1. Solaris 2. Solaris 3. Solaris 4. HP-UX 5. AIX 6. Digital Unix 7. SCO Unix Solaris has much better features and is more reliable as per my experience. For eg. only Solaris provides the option to use Asynchronous I/O for file systems as well as raw devices. Asynchronous I/O on HP will b used only while accessing raw devices. I think that the Oracle software is primarily written on Solaris these days. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 April 2002 15:08 To: Multiple recipients of list ORACLE-L Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WHICH UNIX FOR ORACLE?
Hi Raj, list Few systems running Oracle require market-leading performance to function well. (There are some, don't get me wrong.) So I believe that even if an architecture is slower it can be more appropriate if it's priced right and has other important characteristics. Also, the highest-end machines of the slowest architecture can easily stomp on the mid-range machines of the other architectures. We all agree on that. However, it's my understanding (eager to learn!) that HP is still losing in overall CPU performance to IBM, Sun and Digital/Compaq as a result of the neglect the PA-RISC architecture suffered at the hands of Rick Belluzo. I know that HP has reinvested vast sums of money into it because of the IA-64 delays, but last I heard it had improved things dramatically but not yet enough. Here are some references. Again, I'm very interested in this subject as I'm often called upon to recommend hardware purchases and platform selections. :-) From http://www.itworld.com/Comp/2149/swol-0119-flavors/ (where the other suspects are also reviewed) Hewlett-Packard HP-UX Current release: HP-UX 11i Platform: HP 9000 servers Standard: Unix 95 Application score: 9 out of 10 Advantages: HP has a solid reputation for reliability and service; HP-UX comes with a substantial OS bundle including a Web server, C/C++, Windows networking, WAP (Wireless Application Protocol) services, Linux APIs, iPlanet directory server, and Veritas file system. Disadvantages: HP PA-RISC architecture is falling behind in performance relative to the competition. Prognosis: Hewlett-Packard is the Volvo of IT: It quietly churns out ugly, bulletproof boxes that virtually care for themselves. HP is rarely first or fastest, but it packs enormous value into its Unix products. Not surprisingly, HP-UX is almost Linux-like in its completeness, with time-proven enterprise tools and services included in the bundle. HP's inclusion of the Veritas journaling file system moves HP-UX 11i to the front of the pack. Once HP catches up to rivals' performance and certifies HP-UX as Unix 98-compliant, it could move ahead of Sun and IBM. from... http://www.chipcenter.com/eexpert/dgilbert/dgilbert050.html Hewlett Packard was the first manufacturer to pursue the advantages of using Intel chips in both 32-bit and 64-bit system architectures, and they played a vital role in the development of the new Itanium architecture. This path was taken to get away from pouring more money into their PA-RISC chips, among other reasons. Now the only two players left in the 64-bit RISC game are IBM and Sun Microsystems. IBM has effectively unlimited staying power since they can perform all levels of chip design and production in-house. Sun Microsystems does not enjoy this autonomy since they outsource their manufacturing to Texas Instruments, and it is likely that this factor may ultimately hinder their ability to continue providing their own architecture of RISC processor for the server and workstation market. Is it just a matter of time before we are left with Intel and IBM? Will the RISC architecture be able to carry forward in the server and workstation market? And although this following article has a IBM bias (because of the association with Apple Computer), it's an interesting read that covers the history of the PA/IA-64 fiasco well: http://www.macedition.net/soup/soup_20020318.php Cheers, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 10:48 AM Paul, I am glad you are on your way to 'controlled molecular restructuring and HP-iozation' (??!) ..;) Mind telling me What made you say HP's is losing performance race..? I am on HP mid level (N class) 4 way server 64 bit and our Database is 210 Gigs High end OLTP database with 12 TPS and severe response time restrictions(1 sec or less.) I am beating the response time by several milliseconds and I haven't even maxed out the processors yet...!! HTH Cheers, RS --- Paul Vallee [EMAIL PROTECTED] wrote: This is great information Raj. I've run a test that is completely consistent with this. For instance: Go to Metalink and click the Patches item in the left menu. Then choose product family Oracle Server and product RDBMS Server, release 9.0.1.3. Select the HP9000 Series HP/UX 64-bit platform and choose All Product Patches. Repeat for Sun Sparc Solaris. Although the Sun list is quite lengthy compared to most other platforms (7 entries), the HP list has significantly more patches (15 entries). For me, this is a significant decision influencer when choosing a platform for Oracle. However, HP is definitely losing the performance race... :-) Tough one. Thanks again, Paul ---
Entry Level Pay Question - Revised
Duh, I forgot the word "PAY" in my question. What's the salary range for an entry level certified OracleDBA in the Los Angeles area? Thanks!, JoJo
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
Do not let the kiddo hit return until you've reviewed what is typed on each line. Kudos for making the effort, although a DBA's day would probably create emotional scarring in young children... grin Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Dungey, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Subject: Off topic: Need ideas for 'Take your child to work' day 4/25 Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. -- 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: Exe Loading too slow on DB Server
Could it be the otrace problem? Check to see if you have some large log files in $ORACLE_HOME/otrace/admin If so, there is info on MetaLink on correcting this. Jared On Tuesday 02 April 2002 19:33, VIVEK_SHARMA wrote: Are there any Best Practices of Tuning Solaris 8 for HIGH-End heavily Loaded Machines ? A Brief Description of the Issue Actions Below :- Machine E6500 RAM 20 GB CPUs = 20 SWAP = 26 GB After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus becomes SLOW as the Number of Unix Users Connecting to the Database Increases to about 400 whereafter even after all users are logged out the response continues to be Slow even after the machine is Booted i.e. ON Issuing the Command $ sqlplus it took about 5 minutes for the following Message to appear : - SQL*Plus: Release 8.1.7. 0.0 - Production on Tue Mar 19 09:56:05 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: NOTE - This Slowness is Observed BOTH When Issuing sqlplus Command DIRECTLY on the DB Server Also from the APP Server Via SQL*Net NOTE - In Oracle 7 NO such Slowness was Observed when the Total of 1200 Connect to the Database - Executed truss sqlplus with the Following Output :- $ truss sqlplus execve(/arch/oracle/bin/sqlplus, 0xFFBEFBBC, 0xFFBEFBC4) argc = 1 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 stat(/arch/oracle/bin/sqlplus, 0xFFBEF8F8)= 0 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT open(/arch/oracle/lib/libclntsh.so.8.0, O_RDONLY) = 3 fstat(3, 0xFFBEF28C)= 0 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 mmap(0x, 6717440, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFEC0 mmap(0xFF224000, 209704, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 6373376) = 0xFF224000 mmap(0xFF258000, 58832, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_ANON, -1, 0) = 0xFF258000 munmap(0xFF216000, 57344) = 0 memcntl(0xFEC0, 672560, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 close(3) - WAIT HAPPENING AT THIS POINT ACTIONS ON RE-Creating file libclntsh.so.8.0 using getclntsh on the APP Server Response Message SQL*Plus: Release 8.1.7.2. became FAST ONLY for a FEW Minutes whereafter it again Became Slow Copied libclntsh.so.8.0 to /usr/lib Dir Both on APP DB Servers Set LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib whereafter the response to sqlplus became for Establishment of upto 500 Process Connections Directly on the DB Server . On Adding the Following Parameters to the /etc/system the Slowdown of sqlplus Connect to the Database Started Occuring after 850 Process Connections Instead of 500 (Previously) When Executing Directly on the Database Server machine . set tcp:tcp_conn_hash_size=262144 set rlim_fd_max=8092 set rlim_fd_cur=8092 set autoup=900 set tune_t_fsflushr=1 set bufhwm=8000 INCREASED the Semaphores to the Following Values :- - /etc/system File on the DB APP Servers :- set shmsys:share_page_table=1 set maxuprc=2 set maxusers=1500 set shmsys:shminfo_shmseg=200 set shmsys:shminfo_shmmin=2 set shmsys:shminfo_shmmni=5000 set shmsys:shminfo_shmmax=25769803776 forceload: sys/shmsys forceload: sys/shmsys set semsys:seminfo_semmsl=1000 set semsys:seminfo_semaem=16384 set semsys:seminfo_semmap=70 set semsys:seminfo_semmni=6 set semsys:seminfo_semmns=10 set semsys:seminfo_semmnu=1 set semsys:seminfo_semume=100 set semsys:seminfo_semvmx=32767 Because of Increase of SEMAPHORES ( semmns to 100,000 from 20,000 ) the Slowdown of sqlplus to Establish a Connect to Database started Occuring after 1050 Process Connections Instead of 850 (Previously) . We are yet to try the Settings of Reducing swapfs_minfree , noatime Option with mount , inode cache Hit ratio as advised Below -Original Message- Sent: Wednesday, March 27, 2002 12:11 AM To: VIVEK_SHARMA Servers You may need more swap. I've had the best luck with multiple 1-Gbyte swap partitions on different devices. V After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus V becomes SLOW as the Number of Unix Users Connecting to the Database V Increases to about 400 whereafter even after all users are logged out V the response continues to be Slow even after the machine is Booted Some suggestions are below. You may be spending too much time scanning memory for dirty pages. If you have an application that's an incredible swap hog, or the system is really slowing down, try adding the lines below to /etc/system and rebooting. I run with these settings and they've never caused me trouble. * * Swap * System keeps 1/8th of all memory for swap, which is too much for * a 4GB system. Reduce that to 32 Mbytes (4096 8K pages). set
RE: Bought a Coriolis book at 75% off, how safe is my cust info?
As safe as giving your info over the phone. If they're going to sell it, they're going to sell it... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Brad Weiner [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:37 AM To: Multiple recipients of list ORACLE-L Subject: Bought a Coriolis book at 75% off, how safe is my cust info? On their web site it's 75% off so I finally bought the black book. Now I had to supply my email, credit card #, home address. Since they'll be selling off everything including customer info (I assume), how safe was it, just to save $30 on the book? -- 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: RMAN
Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Deleting old archive log files.
Jared, Without the signature (you've been using before) it's not that persuasive :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 12:08 PM Years of Perl evangelism are finally paying off. :) Jared On Friday 05 April 2002 07:18, Igor Neyman wrote: Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
Re: Slightly OT: Perl Q.
Jack, How about examples? 1) a shell script to set some ENV vars 2) a perl script that should see the newly set vars 3) your command line for running them. Jared On Wednesday 03 April 2002 00:53, Jack van Zanen wrote: Hi All (Jared in particular), OS: AIX We are trying the following: We have a script that executes and sets all sorts of environment variables. Than after this we execute a perl script that reads the environment variables, however the environment variables set in the first script are not picked up. We tried executing the variables script with [ . script] (dot space scriptname) as well but still no luck. How can we make the perl script pick up these variables? TIA and sorry for the OT but I am not using perl so much as to join another mailing list Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MS SQL
Oops, a couple of items I didn't make clear: - I was never able to compare the cost of Oracle support with the cost of Microsoft support. Oracle prices annual maintenance, which includes the right to upgrade to a new version of Oracle. MS prices out per incident or for all MS software at a location. If you can estimate the number of calls/month, then you could compare. - Oracle DBA salary vs. MS SQL DBA salary. I feel the difference is primarily due to less experience, training. I find it ironic that this probably causes less reliability for Microsoft (Microsoft has even complained that organizations don't assign their best people to administer MS products), yet then Microsoft brags about how you can save money because their people are cheaper. -Original Message- Sent: Friday, April 05, 2002 11:14 AM To: Multiple recipients of list ORACLE-L I recently prepared a total cost comparison between Oracle and MS SQL. I appreciate the support several people on this list provided me. In return, here are some of the main points I learned. - For smaller systems, investigate whether Oracle Standard Edition will meet your requirements. For example, most people assume that to use replication, you need EE. For our purposes the basic replication that comes with SE was adequate. - Microsoft also offers SQL in both EE and SE versions. Thanks very much to Gints Plivna for providing me a feature-by-feature comparison between the different versions. MS SE is not equivalent to Oracle SE. In most cases, the more valid comparison is between MS SQL EE and Oracle SE. - For maintenance, there are two parts to consider: Upgrade privilege and support. Oracle bundles both of these together. Make sure Microsoft is priced with Software Assurance, which gives upgrade privilege. Microsoft prices support by the incident or by the location (all Microsoft software). I was never able to get a comparison. - MS SQL EE with Software Assurance is actually more expensive than Oracle SE. Priced by the CPU. - Since pricing is by CPU and RISC systems offer higher database performance (according to many people on this list) and Oracle offers higher performance in a head-to-head comparison (according to the recently published Eweek benchmark), I compared Oracle SE on a 1-CPU Sun box with MS SQL on a 2-CPU Intel box. The Intel box was cheaper, but those two CPUs really kill you on licensing! In my mind I am convinced that both setups could offer equivalent performance. - I was provided figures that the average DBA salary (including health, vacation, etc.) on Oracle is $85,000 and on MS SQL $68,500. A leading industry analyst stated that the main reason MS SQL sites have less reliability is because there are few processes to ensure high availability, high performance. Developing these processes in the MS SQL world is more trial-and-error while these are well-documented in the Oracle world. I would add that several authors that participate in this list have created that documentation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SEQUENCES
There's a short article on that subject at www.cybcon.com/~jkstill Jared On Thursday 04 April 2002 12:58, Seema Singh wrote: Hi I do export and import of one schema from one server to another.But sequences are not matched.How to syncronise all sequences?Can I drop all sequences and create all sequences? o Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: WHICH UNIX FOR ORACLE?
Oh, you miss installing an OS from 96 floppy disks? There's usually a bad disk once you pass #90. Jared On Friday 05 April 2002 06:53, James Morle wrote: Yes, let's not miss an opportunity to remind Evil Bill of his contribution to the wonderful world of UNIX. Xenix/286... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Boivin, Patrice J Sent: 04 April 2002 21:09 To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? How about XENIX? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 04, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: WHICH UNIX FOR ORACLE? I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP, it was Windows. Who cares that it's not as stable as I would like. You should have seen the VP grin at me with this patronizing smile when he said, I'll approve $35,000 for this project!, like he had done me a huge favor. I wanted to growl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Moving From Rule-Based to Cost-Based
Sam, If your SQL has hints in it your using the Cost based optimizer as it is. From my experience an sql statement that is well written from a rule based optimizer point of view will not adversely be affected by the cost based optimizer while the statistics are valid/accurate. Now a poorly written statement with invalid/inaccurate statistics will kill you. And a poorly written statement with valid/accurate statistics will help save the day. I switched out Operational Data Store from rule based to cost based optimization some months ago, like 24 months. And have been computing statistics every weekend. The end users who write their own SQL via Access have never been so pleased. Even their trashy SQL runs relatively quickly. Dick Goulet Reply Separator Author: Sam Bootsma [EMAIL PROTECTED] Date: 4/5/2002 8:49 AM Hello All, At our site, we are use rule based optimization. We are careful to write SQL that performs well under this mode. Some of our SQL also contains hints. When we provide our application to clients, we default it to use Rule-based. However, some clients may choose to run our application in cost-based mode. This will be as simple as analyzing all tables and indexes in our schemas', and changing the mode to use cost based. My Questions: 1. How likely is it that our application will perform worse under cost-based than it does under rule-based. What has been the experience of others on the list who have moved from Rule-based to Cost-based? 2. What are some of the underlying reasons for performance to decline when making such a move? What are some gotchas to watch for? 3. Is there more that needs to be done to move from rule to cost? (Other than changing the optimization mode and analyzing tables and indexes)? Most clients run our database on NT, although some use UNIX. Assume Oracle 9i. Our database (at client sites) tends to be small, with the largest being about 25 GB. Thanks for any suggestions, Sam Bootsma Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Still Problem with ORA-12514
I am really Buffled, and need your help guys. Here is my Tnsnames.ora listener.ora sqlnet.ora in server side: db-name = CMS , db_domain=hollywood , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WHICH UNIX FOR ORACLE?
Nice to hear from you Walt. I'd begun to think you'd crashed your sailplane into the side of a mountain or something. :) Jared On Friday 05 April 2002 09:08, Weaver, Walt wrote: As Steve's bunkermate I'll second the Linux thing. We're having good luck with Linux here. I've done AIX and Solaris, and Linux is up there with'em. --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, April 05, 2002 9:31 AM To: Multiple recipients of list ORACLE-L Lot's of listers have presented nice lists but if you don't have Linux on your list then your experience is woefully incomplete. Long live Linux! The war is on and those who don't join this camp soon will find themselves on the losing side! :-) I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful. Unopinionatedly yours, Archie Bunker Steve Orr -Original Message- Sent: Friday, April 05, 2002 8:34 AM To: Multiple recipients of list ORACLE-L My experiance is just the opposite : 1. Solaris 2. Solaris 3. Solaris 4. HP-UX 5. AIX 6. Digital Unix 7. SCO Unix Solaris has much better features and is more reliable as per my experience. For eg. only Solaris provides the option to use Asynchronous I/O for file systems as well as raw devices. Asynchronous I/O on HP will b used only while accessing raw devices. I think that the Oracle software is primarily written on Solaris these days. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 April 2002 15:08 To: Multiple recipients of list ORACLE-L Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: RMAN
Jared Dennis, The O'Reilly pocket reference on RMAN is very good, at least in my opinion. I reviewed it before it went to press tried just about all of what was offered except the 9i stuff as I don't have it installed anywhere yet. The 8.x stuff all works and makes clear water out of muddy ones. Enjoy. Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 4/5/2002 9:47 AM Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-12514
Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain
RE: Oracle vs. MS SQL
There are some technical points worth considering. For example, SQL Server does not have true row level locking. It's table level locking, or some really creative SQL to fake it. This has a direct impact on scalability and performance. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Oops, a couple of items I didn't make clear: - I was never able to compare the cost of Oracle support with the cost of Microsoft support. Oracle prices annual maintenance, which includes the right to upgrade to a new version of Oracle. MS prices out per incident or for all MS software at a location. If you can estimate the number of calls/month, then you could compare. - Oracle DBA salary vs. MS SQL DBA salary. I feel the difference is primarily due to less experience, training. I find it ironic that this probably causes less reliability for Microsoft (Microsoft has even complained that organizations don't assign their best people to administer MS products), yet then Microsoft brags about how you can save money because their people are cheaper. -Original Message- Sent: Friday, April 05, 2002 11:14 AM To: Multiple recipients of list ORACLE-L I recently prepared a total cost comparison between Oracle and MS SQL. I appreciate the support several people on this list provided me. In return, here are some of the main points I learned. - For smaller systems, investigate whether Oracle Standard Edition will meet your requirements. For example, most people assume that to use replication, you need EE. For our purposes the basic replication that comes with SE was adequate. - Microsoft also offers SQL in both EE and SE versions. Thanks very much to Gints Plivna for providing me a feature-by-feature comparison between the different versions. MS SE is not equivalent to Oracle SE. In most cases, the more valid comparison is between MS SQL EE and Oracle SE. - For maintenance, there are two parts to consider: Upgrade privilege and support. Oracle bundles both of these together. Make sure Microsoft is priced with Software Assurance, which gives upgrade privilege. Microsoft prices support by the incident or by the location (all Microsoft software). I was never able to get a comparison. - MS SQL EE with Software Assurance is actually more expensive than Oracle SE. Priced by the CPU. - Since pricing is by CPU and RISC systems offer higher database performance (according to many people on this list) and Oracle offers higher performance in a head-to-head comparison (according to the recently published Eweek benchmark), I compared Oracle SE on a 1-CPU Sun box with MS SQL on a 2-CPU Intel box. The Intel box was cheaper, but those two CPUs really kill you on licensing! In my mind I am convinced that both setups could offer equivalent performance. - I was provided figures that the average DBA salary (including health, vacation, etc.) on Oracle is $85,000 and on MS SQL $68,500. A leading industry analyst stated that the main reason MS SQL sites have less reliability is because there are few processes to ensure high availability, high performance. Developing these processes in the MS SQL world is more trial-and-error while these are well-documented in the Oracle world. I would add that several authors that participate in this list have created that documentation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with
RE: RMAN
Hey Jared, One of the publishers asked me to write such a book but I declined because: 1) It's a lot of work; 2) It doesn't pay; 3) I'd have to get into 9i and setup quite an infrastructure to do a thorough job and test so many scenarios and setup variables; 4) I lack self confidence; 5) I don't want to be an over-achiever; 6) I want to have a life; 7) Etc. So how's your book coming? :-) Steve Orr Bozeman, MT -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Still Problem with ORA-12514
Hamid, did you try changing SERVICE_NAME to SID within the TNSNAMES file? CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) === change to SID = CMS ) ) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, April 05, 2002 1:08 PM To: Multiple recipients of list ORACLE-L I am really Buffled, and need your help guys. Here is my Tnsnames.ora listener.ora sqlnet.ora in server side: db-name = CMS , db_domain=hollywood , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-12514
Actualy I have 8.1.6 8.1.7 on sun solaris not NT, the things which confusing me is the first day after installation I could connect to database and every thing was fine till I shutdown the database after taht I couldn't conect at all all the time get ora-12514 ERROR!!! don't find any thing between shtdown database this error? -Original Message- Sent: Friday, April 05, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: WHICH UNIX FOR ORACLE?
Nope, just been in major lurk mode for the past few months. :) --Walt -Original Message- Sent: Friday, April 05, 2002 11:02 AM To: [EMAIL PROTECTED]; Weaver, Walt Nice to hear from you Walt. I'd begun to think you'd crashed your sailplane into the side of a mountain or something. :) Jared On Friday 05 April 2002 09:08, Weaver, Walt wrote: As Steve's bunkermate I'll second the Linux thing. We're having good luck with Linux here. I've done AIX and Solaris, and Linux is up there with'em. --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, April 05, 2002 9:31 AM To: Multiple recipients of list ORACLE-L Lot's of listers have presented nice lists but if you don't have Linux on your list then your experience is woefully incomplete. Long live Linux! The war is on and those who don't join this camp soon will find themselves on the losing side! :-) I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful. Unopinionatedly yours, Archie Bunker Steve Orr -Original Message- Sent: Friday, April 05, 2002 8:34 AM To: Multiple recipients of list ORACLE-L My experiance is just the opposite : 1. Solaris 2. Solaris 3. Solaris 4. HP-UX 5. AIX 6. Digital Unix 7. SCO Unix Solaris has much better features and is more reliable as per my experience. For eg. only Solaris provides the option to use Asynchronous I/O for file systems as well as raw devices. Asynchronous I/O on HP will b used only while accessing raw devices. I think that the Oracle software is primarily written on Solaris these days. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 April 2002 15:08 To: Multiple recipients of list ORACLE-L Well, I will put in my two cents since everyone else is. 1.HP-UX 2.HP-UX 3.HP-UX 4.Solaris Oracle works equally well on both of them (IMO) but HP provides you with better support, better hardware, better reliability, etc. Course, none of that is free. All in all I have not been disappointed per say with Solaris (which is a good thing cause I will be working with it ALOT from here on it) but I have had far less issues with HP. -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Another shot across the bow: Hp-UX if you like to sleep at night Solaris if you want speed and sleepless nights Aix if neither of the above is of any value in your life Linux if both are valuable $$$ are a consideration Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 4/4/2002 9:24 AM here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-12514
for unix think env var TNS_ADMIN for nt think registry entry TNS_ADMIN. [EMAIL PROTECTED] 04/05/02 01:07PM Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). === Confidentiality Statement === The information contained in this message and any
Re: Oracle vs. MS SQL
Well, this was almost true for SQL Server 6.5 (only, the lowest locking level was a block, not a table). And it caused a lot of problems, generating tons of deadlocks. Now, latest version of SQL Server provides for row-level locking, but not exactly the way Oracle does it, and also, it's unfortunate, that SQL Server can automatically escalate row-level lock to block-level, or even table-level. MS claims, it does this in order to improve performance. Sorry, don't have first-hand experience to grade this improvement in SQL Server. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 1:33 PM There are some technical points worth considering. For example, SQL Server does not have true row level locking. It's table level locking, or some really creative SQL to fake it. This has a direct impact on scalability and performance. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Oops, a couple of items I didn't make clear: - I was never able to compare the cost of Oracle support with the cost of Microsoft support. Oracle prices annual maintenance, which includes the right to upgrade to a new version of Oracle. MS prices out per incident or for all MS software at a location. If you can estimate the number of calls/month, then you could compare. - Oracle DBA salary vs. MS SQL DBA salary. I feel the difference is primarily due to less experience, training. I find it ironic that this probably causes less reliability for Microsoft (Microsoft has even complained that organizations don't assign their best people to administer MS products), yet then Microsoft brags about how you can save money because their people are cheaper. -Original Message- Sent: Friday, April 05, 2002 11:14 AM To: Multiple recipients of list ORACLE-L I recently prepared a total cost comparison between Oracle and MS SQL. I appreciate the support several people on this list provided me. In return, here are some of the main points I learned. - For smaller systems, investigate whether Oracle Standard Edition will meet your requirements. For example, most people assume that to use replication, you need EE. For our purposes the basic replication that comes with SE was adequate. - Microsoft also offers SQL in both EE and SE versions. Thanks very much to Gints Plivna for providing me a feature-by-feature comparison between the different versions. MS SE is not equivalent to Oracle SE. In most cases, the more valid comparison is between MS SQL EE and Oracle SE. - For maintenance, there are two parts to consider: Upgrade privilege and support. Oracle bundles both of these together. Make sure Microsoft is priced with Software Assurance, which gives upgrade privilege. Microsoft prices support by the incident or by the location (all Microsoft software). I was never able to get a comparison. - MS SQL EE with Software Assurance is actually more expensive than Oracle SE. Priced by the CPU. - Since pricing is by CPU and RISC systems offer higher database performance (according to many people on this list) and Oracle offers higher performance in a head-to-head comparison (according to the recently published Eweek benchmark), I compared Oracle SE on a 1-CPU Sun box with MS SQL on a 2-CPU Intel box. The Intel box was cheaper, but those two CPUs really kill you on licensing! In my mind I am convinced that both setups could offer equivalent performance. - I was provided figures that the average DBA salary (including health, vacation, etc.) on Oracle is $85,000 and on MS SQL $68,500. A leading industry analyst stated that the main reason MS SQL sites have less reliability is because there are few processes to ensure high availability, high performance. Developing these processes in the MS SQL world is more trial-and-error while these are well-documented in the Oracle world. I would add that several authors that participate in this list have created that documentation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
RE: RMAN
Steve, You can get help from some of the list members. Where's Alex H. ?? ;) Now, I duck behind the empty boxes in my cube !!! ;) TGIF !! -Kirti -Original Message- Sent: Friday, April 05, 2002 12:47 PM To: Multiple recipients of list ORACLE-L Hey Jared, One of the publishers asked me to write such a book but I declined because: 1) It's a lot of work; 2) It doesn't pay; 3) I'd have to get into 9i and setup quite an infrastructure to do a thorough job and test so many scenarios and setup variables; 4) I lack self confidence; 5) I don't want to be an over-achiever; 6) I want to have a life; 7) Etc. So how's your book coming? :-) Steve Orr Bozeman, MT -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Copy tables and indexes etc from one db to another
You are setting up yourself for many more questions from the author of the original post :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 1:54 PM I would recommend using a dblink. And I don't say *that* very often! Set up a dblink to the source database and run CREATE TABLE new SELECT * FROM old@dblink; If you set up your SDU size to be large (ie 32K), it is possible to drive the network pretty close to full capacity. If your database is too large for this method, maybe transportable tablespaces via sneakernet (tape)? One thing to watch with the dblink option is that LONG datatypes are not supported. Regards James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: 05 April 2002 14:18 To: Multiple recipients of list ORACLE-L Subject: Copy tables and indexes etc from one db to another Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copy tables and indexes etc from one db to another
Or, consider export/import over UNIX pipes. - Kirti -Original Message- Sent: Friday, April 05, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I would recommend using a dblink. And I don't say *that* very often! Set up a dblink to the source database and run CREATE TABLE new SELECT * FROM old@dblink; If you set up your SDU size to be large (ie 32K), it is possible to drive the network pretty close to full capacity. If your database is too large for this method, maybe transportable tablespaces via sneakernet (tape)? One thing to watch with the dblink option is that LONG datatypes are not supported. Regards James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: 05 April 2002 14:18 To: Multiple recipients of list ORACLE-L Subject: Copy tables and indexes etc from one db to another Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN
Steve, Quite an impressive list to discourage anyone :)) And you are asking how's Jared's book coming :)) And no, I never thought about it (writing on Oracle issues) exactly because of p.5 you listed, though I wrote several articles on SQL Server (for SQL Server Professional), but Oracle is so much deeper. When I was dealing with SQL Server, I felt, that I know everything about it, while with Oracle, it feels like just touching the surface. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 1:46 PM Hey Jared, One of the publishers asked me to write such a book but I declined because: 1) It's a lot of work; 2) It doesn't pay; 3) I'd have to get into 9i and setup quite an infrastructure to do a thorough job and test so many scenarios and setup variables; 4) I lack self confidence; 5) I don't want to be an over-achiever; 6) I want to have a life; 7) Etc. So how's your book coming? :-) Steve Orr Bozeman, MT -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sqlplus Auto-trim Whitespace???
Hi, A co-worker of mine is trying to remember how to have trailing whitespace automatically removed from each COLUMN in the output of a query within SQL*Plus. He said he saw the tip in a book a couple years ago and can't remember for the life of him how he went about it. I have poured through the docs myself and other references and can't seem to find a way to do this. The objective is to set the COLSEP to say '|' and then be able to perform something like a SELECT * FROM table such that the output/display is variable length for each column. The solution we're looking for is purely within SQL*Plus, not doing something with PL/SQL. Also, the solution should not involve using the COLUMN command to control the formatting of each column literally. Anyone know how to do this? Does anyone remember the tip and possibly the name of the book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
User Logon Auditing
Greetings, I have a request from my boss to come up with a list of users for a particular database. Since this is 805 database logon trigger is not an option. Turning on audit trail will be an overkill and not sure if performance will be acceptable if we do that. Other than querying v$session periodically and hoping to get everybody, is there a better way to do this? DBA_USERS view is not going to work because there are too many duplicate and obsolete entries. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: Still Problem with ORA-12514
Another thing is when I do TNSPING to the instance it's OK but still can not connect, ORA-12514 ! -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Hamid, did you try changing SERVICE_NAME to SID within the TNSNAMES file? CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) === change to SID = CMS ) ) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, April 05, 2002 1:08 PM To: Multiple recipients of list ORACLE-L I am really Buffled, and need your help guys. Here is my Tnsnames.ora listener.ora sqlnet.ora in server side: db-name = CMS , db_domain=hollywood , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). === Confidentiality Statement === The information contained in this message and any
RE: RMAN
I could use some professional help, Walt will vouch for that. :-) -Original Message- Sent: Friday, April 05, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Importance: High Steve, You can get help from some of the list members. Where's Alex H. ?? ;) Now, I duck behind the empty boxes in my cube !!! ;) TGIF !! -Kirti -Original Message- Sent: Friday, April 05, 2002 12:47 PM To: Multiple recipients of list ORACLE-L Hey Jared, One of the publishers asked me to write such a book but I declined because: 1) It's a lot of work; 2) It doesn't pay; 3) I'd have to get into 9i and setup quite an infrastructure to do a thorough job and test so many scenarios and setup variables; 4) I lack self confidence; 5) I don't want to be an over-achiever; 6) I want to have a life; 7) Etc. So how's your book coming? :-) Steve Orr Bozeman, MT -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: User Logon Auditing
Dennis, How about using the listner.log file and gathering information on the USER and HOST columns. That will tell you the login id and the name/ip of the machine they logged in from. ROR mª¿ªm [EMAIL PROTECTED] 04/05/02 02:25PM Greetings, I have a request from my boss to come up with a list of users for a particular database. Since this is 805 database logon trigger is not an option. Turning on audit trail will be an overkill and not sure if performance will be acceptable if we do that. Other than querying v$session periodically and hoping to get everybody, is there a better way to do this? DBA_USERS view is not going to work because there are too many duplicate and obsolete entries. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlplus Auto-trim Whitespace???
SET TRIMSPOOL ON -Original Message- Sent: Friday, April 05, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Hi, A co-worker of mine is trying to remember how to have trailing whitespace automatically removed from each COLUMN in the output of a query within SQL*Plus. He said he saw the tip in a book a couple years ago and can't remember for the life of him how he went about it. I have poured through the docs myself and other references and can't seem to find a way to do this. The objective is to set the COLSEP to say '|' and then be able to perform something like a SELECT * FROM table such that the output/display is variable length for each column. The solution we're looking for is purely within SQL*Plus, not doing something with PL/SQL. Also, the solution should not involve using the COLUMN command to control the formatting of each column literally. Anyone know how to do this? Does anyone remember the tip and possibly the name of the book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sqlplus Auto-trim Whitespace???
Try either set trimout on or set trimspool on The first one affects screen output, the second one takes care of spooled output. Rodd On Fri, 2002-04-05 at 13:36, Walter K wrote: Hi, A co-worker of mine is trying to remember how to have trailing whitespace automatically removed from each COLUMN in the output of a query within SQL*Plus. He said he saw the tip in a book a couple years ago and can't remember for the life of him how he went about it. I have poured through the docs myself and other references and can't seem to find a way to do this. The objective is to set the COLSEP to say '|' and then be able to perform something like a SELECT * FROM table such that the output/display is variable length for each column. The solution we're looking for is purely within SQL*Plus, not doing something with PL/SQL. Also, the solution should not involve using the COLUMN command to control the formatting of each column literally. Anyone know how to do this? Does anyone remember the tip and possibly the name of the book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: User Logon Auditing
[EMAIL PROTECTED] wrote: Greetings, I have a request from my boss to come up with a list of users for a particular database. Since this is 805 database logon trigger is not an option. Turning on audit trail will be an overkill and not sure if performance will be acceptable if we do that. Other than querying v$session periodically and hoping to get everybody, is there a better way to do this? DBA_USERS view is not going to work because there are too many duplicate and obsolete entries. TIA Dennis Meng Database Administrator Focal Communications Corp. Why do you say that auditing will be an overkill? You do not have to record everything. You can have as little as storing a row into SYS.AUD$ each time somebody connects. Bearable. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN
Jared - Well, if the tech book market is in the dumps, it isn't my fault. I've bought 2 Oracle books this week. I would still argue that an RMAN for Dummies or RMAN 101 book would have a wide audience because RMAN is a standard part of Oracle so a lot of sites will be taking a look at it. You know, for people that don't know what esoteric means :-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 05, 2002 11:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG test database that I would like to use Rman on and I am not going to use a catalog for RMAN. I have a system tape drive that I would like to use to backup each tablespace individually. I do not have a large or multi cartridge drive to use. Backup to disk is not possible as I do not have much free space. Could you please inform me of the contents of your V$BACKUP_DEVICE.DEVICE_NAME if you use a tape drive for backups. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlplus Auto-trim Whitespace???
Walter, set trimspool ON (or set trimsp on or set trims on) you can also use show all at the sqlplus prompt to get an idea about what other options have been set (if you don't remember the command). Margaret -Original Message- From: Walter K [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Sqlplus Auto-trim Whitespace??? Hi, A co-worker of mine is trying to remember how to have trailing whitespace automatically removed from each COLUMN in the output of a query within SQL*Plus. He said he saw the tip in a book a couple years ago and can't remember for the life of him how he went about it. I have poured through the docs myself and other references and can't seem to find a way to do this. The objective is to set the COLSEP to say '|' and then be able to perform something like a SELECT * FROM table such that the output/display is variable length for each column. The solution we're looking for is purely within SQL*Plus, not doing something with PL/SQL. Also, the solution should not involve using the COLUMN command to control the formatting of each column literally. Anyone know how to do this? Does anyone remember the tip and possibly the name of the book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN
Let's just say that someone on this list *is* talking to a publisher seriously about such a book. Stay tuned true believer. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Friday, April 05, 2002 2:52 PM To: Multiple recipients of list ORACLE-L I could use some professional help, Walt will vouch for that. :-) -Original Message- Sent: Friday, April 05, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Importance: High Steve, You can get help from some of the list members. Where's Alex H. ?? ;) Now, I duck behind the empty boxes in my cube !!! ;) TGIF !! -Kirti -Original Message- Sent: Friday, April 05, 2002 12:47 PM To: Multiple recipients of list ORACLE-L Hey Jared, One of the publishers asked me to write such a book but I declined because: 1) It's a lot of work; 2) It doesn't pay; 3) I'd have to get into 9i and setup quite an infrastructure to do a thorough job and test so many scenarios and setup variables; 4) I lack self confidence; 5) I don't want to be an over-achiever; 6) I want to have a life; 7) Etc. So how's your book coming? :-) Steve Orr Bozeman, MT -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Not very likely. The tech book market is in the dumps already, and this book would be rather esoteric. Jared On Thursday 04 April 2002 12:08, DENNIS WILLIAMS wrote: Ron Hopefully one of the authors on the list is writing the great RMAN book that people like me need so much. In the meanwhile, check out Oracle RMAN Pocket Reference from O'Reilly. At only $10 you can't pass it up. Jonathan Gennick who participates on this list edited it. For us, hot backups never worked out. That is why we are looking at RMAN. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).