Re: ORA-01000: maximum open cursors exceeded
It can be set to much higher values if the need is there. There used to be some kind of limit depending on the various 7-versions as far as I remember. Personally, I haven't seen the need for anything higher than 2000 more than once or twice. Mogens [EMAIL PROTECTED] wrote: Hi I think u can increase the open cursors at the maximum. currently I am having open cursors as 2000. so I think u can increase up to that Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Long running SQL Problem?
Catherine, I am sure that Larry Elkins will forgive my taking the opportunity of being 7 hours ahead of him (and 7 hours behind yourself) for singing the praise of the 'hash anti-join' in his name. And anyway you could remind your senior DBA the existence of NOT EXISTS, far better than COUNT(*) in this case. Basically, in case A you have a non-correlated sub-query, and in case B a correlated one. A correlated sub-query means that for each row from Table_1 you must search Table_2. For one thing, if the corresponding columns are not indexed, you're dead. Even if they are, it may really be bad if Table_1 is huge AND THERE IS NO OTHER CRITERION, because you will have a full scan of Table_1. A non-correlated subquery is executed only once. If it returns few rows, you will have a full TS of Table_1 in both cases, but the NOT IN is likely to be slightly more efficient. If it returns many rows, if Table_1 is big, if there is no other criterion and if col3 and col4 are not null, then the NOT IN with a hint asking for a hash anti-join will outperform a NOT EXISTS, not to mention a 0 = (select COUNT(*) ...). The nested loops of a correlated subquery will be excellent when you have fairly selective criteria besides, and when the correlated subquery is, so to speak, the icing on the cake. Let me add that an external join with a test for nullity usually gives fairly good results too (in fact, it often goes the hash antijoin way) and that I have also had excellent results under some circumstances with an inline view (typically when you have additional criteria bearing on Table_2) ... To summarize, abruptly saying 'this sucks' exposes you to be proved wrong once in a while. - Original Message - From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 02 Apr 2002 21:13:19 Hi Gurus, My senior DBA always tell us that the not in command sucks and we are all encourage to use the select count(*). SQL A is greatly frowned upon and SQL B will be the best. SQL A : SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2 WHERE col3 = col1 AND col4 = col2); SQL B : SELECT col1,col2 FROM Table_1 A WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND b.col4=a.col2)); Qn : Is it true ? Could someone shed some light ? Please advise. Thanks. Regds, Catherine Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- 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).
Creating staging area from Windows client
All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Slightly OT: Perl Q.
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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
problems in oracle report
Hi All Gurus! I have few problems related to oracle report. Problems are listed below: 1. How can a report be editied after its generation in previewer at runtime? 2. In After_Parameter_Form trigger, we check no of records to be displayed and if it is zero then we are able to display a customised message Records not exist. After this this trigger is failed. Now the problem is that Report Builder is giving message REP-0771: After Form Trigger Failed. We don't want this message. How can we suppress this message REP-0771: After Form Trigger Failed? 3. In the previewer we have a main-menu item File. Under this few sub-menu items are displayed like Page Setup, Print, Mail, Distribute and Generate to File. How can we hide these sub-menu items? Hints/reply/solution will be highly appreciated. Thanks in advance Atul Kumar 11-91-9810350959 11-91-6817384 11-91-6817385 11-91-6817386 11-91-6817387 11-91-6817388 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Creating staging area from Windows client
Its a kludge but have you tried chmod 777-ing the entire stage area after copying? hth connor --- Hately Mike [EMAIL PROTECTED] wrote: All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Trigger question
Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been inserted in the table. So the UPPer command should run on the namn field that has been inserted in the table. Hope anyone can´help me. CREATE OR REPLACE TRIGGER AFTER_INSERT_ROWins_ON_test after insert ON test REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN :NEW.namn :=UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); -- :NEW.namn := UPPER(SUBSTR(:OLD.namn, 1, 1) || SUBSTR(:OLD.namn), 2); EXCEPTION WHEN OTHERS THEN raise_application_error(-2, 'ERROR IN TRIGGER AFTER_INSERT_ROWins_ON_test: ' || SQLERRM); END; / Thanks in advance Roland S -- 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: problems in oracle report
Hi Atul kumar 1. How can a report be editied after its generation in previewer at runtime? Which object you wanna to edit or modify . 2. In After_Parameter_Form trigger, we check no of records to be displayed and if it is zero then we are able to display a customised message Records not exist. After this this trigger is failed. Now the problem is that Report Builder is giving message REP-0771: After Form Trigger Failed. We don't want this message. How can we suppress this message REP-0771: After Form Trigger Failed? Solution:- You can write After_Parameter_Form trigger BEGIN SELECT count(*) INTOlv_count FROMhr_people WHERE country_code =:p_country_code ; IF lv_count = 0 THEN srw.message(20, 'No reocrd found'); raise srw.program_abort; END IF; EXCEPTION when OTHERS then srw.message(30, 'Error in reports.'); raise srw.program_abort; END; 3. In the previewer we have a main-menu item File. Under this few sub-menu items are displayed like Page Setup, Print, Mail, Distribute and Generate to File. How can we hide these sub-menu items? you have to run R30RUN32.EXE Mode Hope this will help you. Nitheesh . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trigger question
As the this is a NEW record there is no OLD value! (and would it be bette to use a BEFORE insert?) Regards torben [EMAIL PROTECTED] writes: Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been inserted in the table. So the UPPer command should run on the namn field that has been inserted in the table. Hope anyone can´help me. CREATE OR REPLACE TRIGGER AFTER_INSERT_ROWins_ON_test after insert ON test REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN :NEW.namn :=UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); -- :NEW.namn := UPPER(SUBSTR(:OLD.namn, 1, 1) || SUBSTR(:OLD.namn), 2); EXCEPTION WHEN OTHERS THEN raise_application_error(-2, 'ERROR IN TRIGGER AFTER_INSERT_ROWins_ON_test: ' || SQLERRM); END; / Thanks in advance Roland S -- 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). Torben Holm Miracle A/S mobil: +45 2527 7104 mail : [EMAIL PROTECTED] http://www.miracleas.dk -- 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: Creating staging area from Windows client
Hi, Should work fine with binary FTP, Using it right now for the upgrade to 8.1.7.3 W2K and AIX is my environment Jack Hately Mike Mike.Hately@churTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] chill.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Creating staging area from Windows client [EMAIL PROTECTED] 03-04-2002 10:48 Please respond to ORACLE-L All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == 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.
RE: Creating staging area from Windows client
Hey Connor, kludges make the world go round! I've got it installed just by making the following files executable : /tmp/scratch/817/disk1/runInstaller /tmp/scratch/817/disk1/install/solaris/runInstaller /tmp/scratch/817/disk1/lsm/lsminst and I haven't seen any problems so far. I think the fact that most of the installer is Java means that this problem affects the bare minimum of files. Thanks for the suggestion, though I was trying to avoid that solution =) Now I have to try the same thing with 9iAS ! Cheers, Mike -Original Message- Sent: 03 April 2002 11:43 To: Multiple recipients of list ORACLE-L Its a kludge but have you tried chmod 777-ing the entire stage area after copying? hth connor --- Hately Mike [EMAIL PROTECTED] wrote: All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to:
RE: Trigger question
Roland, First thing would be that as it is an on insert trigger the OLD reference is not valid (only valid for update and delete I think) though I'm surprised that it accepts the referencing old as old part. Iain Nicoll -Original Message- Sent: Wednesday, April 03, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been inserted in the table. So the UPPer command should run on the namn field that has been inserted in the table. Hope anyone can´help me. CREATE OR REPLACE TRIGGER AFTER_INSERT_ROWins_ON_test after insert ON test REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN :NEW.namn :=UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); -- :NEW.namn := UPPER(SUBSTR(:OLD.namn, 1, 1) || SUBSTR(:OLD.namn), 2); EXCEPTION WHEN OTHERS THEN raise_application_error(-2, 'ERROR IN TRIGGER AFTER_INSERT_ROWins_ON_test: ' || SQLERRM); END; / Thanks in advance Roland S -- 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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Trigger question
BDY.RTF Description: RTF file
Re: Trigger question
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 14:08 Hallo, What is wrong with this trigger: many things are wrong with this trigger, for example: - the OLD pseudo column is defined only for UPDATE and DELETE statements, but not for INSERT ones - the NEW pseudo column cannot be changed in AFTER trigger read the docs starting with Using Triggers from the Oracle9i Application Developer's Guide hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix at command ???
Janet, From the command line type man at and you will see the correct format to enter a at string. The basic format is at -f file_to_execute HH:MM This will execute the file at the time specified if the time is in the future. If the time is in the past it will take the next occurrence of the time(tomorrow). You can also use the MMDDYY in the string to specify the date to execute the file. at is used for a one time execution of a command. If you would like the command to execute at a set repetition use cron ROR mª¿ªm Janet Linsy janetlinsy@ya To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hoo.com cc: Sent by: Subject: Unix at command ??? [EMAIL PROTECTED] om 04/02/02 03:14 PM Please respond to ORACLE-L Hi all, I'd like to run a file (r2) at 15:10 Apr 2. Below was what I did and I could not get out of at normally. /export/home/oracle/test$ at 15:10 Apr 2 at r2 at EOF at EOF at EOT at EOT at ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2 I tried EOF according to the on-line doc, and also tried EOT, but none works. Finally I used Control Z to get out of at. I was out, but the script file didn't run. So what's the correct syntax to run the command at a specific date, time? Thank you! Janet __ 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: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
trace external procedure listener
We have occasional problems with the external procedure listener... ORA-28575 unable to open RPC connection to external procedure agent. We are finding it very difficult to track down the source of these errors. Is there anyway to trace what the external procedure was trying to run when these errors were encountered, as these errors occur very sporadically. We use the external procedure listener to run unix commands via a C routine. Oracle is 8.1.7 on AIX. T.I.A. 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: Database shut itself down
My NT admins are great for doing things and not telling me. Monday they changed a system password that a mail routing server uses. After a day and a half of trying to figure out what was wrong with the mail router one of the admins finally says, Oh yea, I changed the password. I simply change the lgin password for the mail router and everything works fine. About all I can say about the NT admin is dumbass. Dave -Original Message- Sent: Tuesday, April 02, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Hi Lisa Just check that the files owner is who you think it should be and check the permissions. A great thing NT Admins are god for is changing permissions in a directory at teh top of a tree and propagating it down with teh include subdirectories checkbox. the OS error Access denied says either you don't have permissions on the file or another process is holding a file lock on it. A reboot of teh server should clear that if you cant resolve it by other means Oh and you are right Oracle holds exclusive locks on the files at the OS level and as such if you try and move or delete them it won't happen Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Koivu, Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2002 07:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Database shut itself down I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To:Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Koivu, Lisa
Re: Database shut itself down
One correction: Oracle holds shared lock on the files, not exclusive. If it'd be exclusive - hot backup would be impossible. Still, shared lock is enough to prevent from deleting, moving, or renaming file. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 5:48 PM Hi Lisa Just check that the files owner is who you think it should be and check the permissions. A great thing NT Admins are god for is changing permissions in a directory at teh top of a tree and propagating it down with teh include subdirectories checkbox. the OS error Access denied says either you don't have permissions on the file or another process is holding a file lock on it. A reboot of teh server should clear that if you cant resolve it by other means Oh and you are right Oracle holds exclusive locks on the files at the OS level and as such if you try and move or delete them it won't happen Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Koivu, Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2002 07:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Database shut itself down I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To:Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
technet download problem
is anyone else able to download anythning from technet, all i get is unable to find server errors. i dont think its a firewall issue as we dont block any ports. thanks, joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Literal SQL and sys.dual
The error is in your code, you are explicitly telling oracle that the bind variables are varchar2, so why would Oracle evaluate it? Try this ... DECLARE nnum1 NUMBER; nnum2 NUMBER; nresult NUMBER; BEGIN BEGIN nnum1 := 0; EXECUTE IMMEDIATE USING nnum1, OUT nresult; dbms_output.put_line(TO_CHAR(nresult)); END; BEGIN nnum1 := 1; nnum2 := 1; EXECUTE IMMEDIATE 'begin SELECT :1 + :2 INTO :0 FROM dual; END;' USING nnum1, nnum2, OUT nresult; dbms_output.put_line(TO_CHAR(nresult)); END; END; / Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: sysdba
Well, with all this info I can't imagine that someone will not be able to help you. -Original Message- paPIpapupapePO Sent: Tuesday, April 02, 2002 9:18 PM To: Multiple recipients of list ORACLE-L i cant connect as sysdba. ORA-01031 - insuffecient privileges. can anybody help me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Long running SQL Problem?
I would rewrite it with a where not exists But that is just me. I would also not bother selecting anything in the subquery. Just a 1 or a 'x' would do. Don't return stuff from the database that you don't want. All you care is whether or not there is a record in the subquery not what it is or how many there are. When you have that criteria think EXISTS. -Original Message- Sent: Tuesday, April 02, 2002 10:48 PM To: Multiple recipients of list ORACLE-L Why not code up a couple of SQL's and try it out? I just tried a couple of examples that match your code, and the NOT IN version was slightly faster, so I'm not frowning upon it. ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 9:13 PM Hi Gurus, My senior DBA always tell us that the not in command sucks and we are all encourage to use the select count(*). SQL A is greatly frowned upon and SQL B will be the best. SQL A : SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2 WHERE col3 = col1 AND col4 = col2); SQL B : SELECT col1,col2 FROM Table_1 A WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND b.col4=a.col2)); Qn : Is it true ? Could someone shed some light ? Please advise. Thanks. Regds, Catherine -Original Message- Sent: Wednesday, March 27, 2002 8:19 PM To: CHAN Chor Ling Catherine (CSC) Hello Catherine Thanks first of all for your suggestions. The indexes were already in exitance before your email, so I did not even try that. But your query and that of Marco van Rooy ran exactly the same number of seconds. They are both basicly the same. Marco's looked like this... SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2 WHERE col3 = col1 AND col4 = col2); Because both yours and Marcos brought the data back in so short a time *16sec*, I have not yet experimented with any of the others. Thanks again Rgds Denham -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, March 27, 2002 2:00 PM To: '[EMAIL PROTECTED]' Hi Denham, I would like to know which solution is the fastest. Regds, Catherine -Original Message- Sent: Wednesday, March 27, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Hi List Thank you to everyone who took the time to answer, I never realised that there could be so many solutions :) Rgds Denham -Original Message- Sent: Wednesday, March 27, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Hello List Is there anyone who can give me a solution to this problem. It is a sql that runs forever and I eventually have to kill it, both tables are large 50 + rows. Is there perhaps a quicker more effecient way of doing this. SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2); TIA Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com http://www.marshalsoftware.com www.marshalsoftware.com _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com http://www.marshalsoftware.com www.marshalsoftware.com _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: sysdba
Did you create an externally identified account? Did you grant sysdba this priv? Only sys has it automagically. Everyone else needs to have it granted. -Original Message- paPIpapupapePO Sent: Wednesday, April 03, 2002 12:08 AM To: Multiple recipients of list ORACLE-L i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Long running SQL Problem?
Use 'exists' or 'not exists' only if you have index on col3 and col4 on table_2 that can be used in the sub-query, else the query will be running like a dog. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: trace external procedure listener
John, Your error message doesn't seem to hint at a problem with what the external procedure was trying to run specifically, but in the 'call' to extproc. If I were you I'd try to put the listener in trace mode, as it looks like that's where the problem occurs. HTH. - Original Message - From: John Dunn [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 03 Apr 2002 04:43:37 We have occasional problems with the external procedure listener... ORA-28575 unable to open RPC connection to external procedure agent. We are finding it very difficult to track down the source of these errors. Is there anyway to trace what the external procedure was trying to run when these errors were encountered, as these errors occur very sporadically. We use the external procedure listener to run unix commands via a C routine. Oracle is 8.1.7 on AIX. T.I.A. 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). --- - Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- 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: sysdba
[EMAIL PROTECTED] wrote: i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. are you starting sqlplus from an account in the DBA group? is the DBA group the primary group? -- -- 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. Youth and skill are no match for experience and treachery. -- 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).
Connecting to Oracle via Perl
Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is appreciated? I do not have any kind of password server. Thanks Rick -- 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: 8.0.5 -- 8.1.7 apps upgrade
I've done this in the past: Install 8.1.7 and create a database (same SID as your current database). Create the same tablespaces and users as your current database. Export your old database and import it into your new database. Be sure to use the same level client software for the export and import. I'd use the 8.1.7 software personally. Point your SQLNet at the new database. Fedock, John (KAM.RHQ) To: Multiple recipients of list ORACLE-L John.Fedock [EMAIL PROTECTED] @KLINE.com cc: Sent by: rootSubject: 8.0.5 -- 8.1.7 apps upgrade 04/02/2002 05:05 PM Please respond to ORACLE-L Looking into how to do this. The 8.0.5 database is on NT. The 8.1.7 is on Windows2000. I thought I could: - shut down database on 8.0.5 (on NT) - copy datafiles to windows 2000 server. - start 8.1.7 service on windows2000 server - run cat08005.sql scripts on windows2000 server - finish other tasks This way I could move the database and upgrade in 1 step. Oracle is saying I cannot do it this way. They are stating I must Migrate the Database from 805 to 817 on a Supported Platform and THEN move the database from one machine to another. To do this, I will then have to install 8.1.7 on my current production server (NT), do the upgrade and then move the database to the new windows2000 server. Is there a better way? Thanks in advance. John Fedock K Line America, Inc. [EMAIL PROTECTED] www.kline.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fedock, John (KAM.RHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dynamic create and execute procedure
execute immediate is your ticket, now not knowing (as Jack puts it) 'desirements', it is difficult to help you further. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Help needed
HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dynamic create and execute procedure
It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list ORACLE-L Sent by: root[EMAIL PROTECTED] cc: Subject: Re: Dynamic create and execute 04/02/2002 procedure 06:28 PM Please respond to ORACLE-L What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Bernard, Gilbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30/03/2002 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Dynamic create and execute procedure I need to create a generic dynamic procedure to create and execute any procedure I wish. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies
RE: Connecting to Oracle via Perl
You might want to check out Jared's site since he kind of likes perl. http://www.cybcon.com/~jkstill/util/ Dave -Original Message- Sent: Wednesday, April 03, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is appreciated? I do not have any kind of password server. Thanks Rick -- 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: 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: RE: License standby database?
Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- Post, Ethan [EMAIL PROTECTED] wrote: Not sure this is correct Rachel. I sat in a conference call today with some folks and an Oracle rep and it was stated that any type of HA software being used would require additional licenses for the all possible servers in the failover cluster. So even if Oracle is not running on server B until A fails I would need a license for B. Of course the whole reason for the call was to discuss Oracles evolving licensing model. Can anyone else confirm or deny? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database shut itself down
You are most likely correct Lisa. I have never tried on NT but I have seen that error on Unix and that is one of the most likely causes is that someone has deleted the data file. I can confirm that the delete definitely works under the Unix o/s for better or worse. -Original Message- Sent: 02 April 2002 22:38 To: Multiple recipients of list ORACLE-L I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Hi Rick, Here's what I did... granted I have never been able to get os-authenticated logons to work on Windows (have you?) * Created a config file that has pairs of values (ex: elvis_pw elvis) * Created a module that accepts a hash as a parameter, reads the config file, populates the hash with the pairs of values, and returns the hash to the calling program. * 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. Not pretty but it works. My password is only stored in one place. If you'd like to see the code email me directly. Lisa Koivu Oracle Database TANK Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Subject: Connecting to Oracle via Perl Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is appreciated? I do not have any kind of password server. Thanks Rick -- 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help needed
Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8.0.5 -- 8.1.7 apps upgrade
How about installing 8.1.7 on your NT server and migrating the database on it's current server? You need the 8.0.5 software to do the migration. The 8.1.7 mig utility is actually placed in the 8.0.5 ORACLE_HOME. Jared On Tuesday 02 April 2002 14:05, Fedock, John (KAM.RHQ) wrote: Looking into how to do this. The 8.0.5 database is on NT. The 8.1.7 is on Windows2000. I thought I could: - shut down database on 8.0.5 (on NT) - copy datafiles to windows 2000 server. - start 8.1.7 service on windows2000 server - run cat08005.sql scripts on windows2000 server - finish other tasks This way I could move the database and upgrade in 1 step. Oracle is saying I cannot do it this way. They are stating I must Migrate the Database from 805 to 817 on a Supported Platform and THEN move the database from one machine to another. To do this, I will then have to install 8.1.7 on my current production server (NT), do the upgrade and then move the database to the new windows2000 server. Is there a better way? Thanks in advance. John Fedock K Line America, Inc. [EMAIL PROTECTED] www.kline.com -- 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: RE: License standby database?
HA is different from Standby. Standby is an Oracle DB in recovery, i.e. Oracle running on 2 servers. HA is a DB Server waiting to become the prod DB via shared storage, i.e. Oracle running on 1 server. [EMAIL PROTECTED] 04/03/02 09:28AM Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- Post, Ethan [EMAIL PROTECTED] wrote: Not sure this is correct Rachel. I sat in a conference call today with some folks and an Oracle rep and it was stated that any type of HA software being used would require additional licenses for the all possible servers in the failover cluster. So even if Oracle is not running on server B until A fails I would need a license for B. Of course the whole reason for the call was to discuss Oracles evolving licensing model. Can anyone else confirm or deny? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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).
Re: Help needed
Rakesh, You have 2 options. 1. Either create the different partitions on different tablespaces and take backup of selected tablespaces 2. You can take a logical backup using the export utility by providing a query clause for the table. HTH, Naveen --- rakesh banerjee [EMAIL PROTECTED] wrote: HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Literal SQL and sys.dual
Thanks for the help. You are right on the money. However, I am getting the data as strings and I do not know what I will get. I get hundreds of thousands of them and I have no idea what they would look like. I might get any string. couple of examples: select 1 + 1 + 1 + 1 from dual select 1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0) So my requirement is different. When I use bind variables, either I use a bind variable for each literal and it will work, or use one bind variable for all literals and then all I will get back is one of the above string in the result set. The best answer is tht programmer should calculate the data as it comes in based on the token he gets and when he/she parses the data coming from the table. This might take place eventually. Right now I am trying to reduce huge library cache and shared pool contentions by elimating literal non-shared SQL. I come from C/C++/Pro*C development environment and I can not imagine ever using sys.dual to do arithmatic. Shakir --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: The error is in your code, you are explicitly telling oracle that the bind variables are varchar2, so why would Oracle evaluate it? Try this ... DECLARE nnum1 NUMBER; nnum2 NUMBER; nresult NUMBER; BEGIN BEGIN nnum1 := 0; EXECUTE IMMEDIATE USING nnum1, OUT nresult; dbms_output.put_line(TO_CHAR(nresult)); END; BEGIN nnum1 := 1; nnum2 := 1; EXECUTE IMMEDIATE 'begin SELECT :1 + :2 INTO :0 FROM dual; END;' USING nnum1, nnum2, OUT nresult; dbms_output.put_line(TO_CHAR(nresult)); END; END; / Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ 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: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Server vs. Oracle 9i
This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
RE: Dynamic create and execute procedure
http://www.fixedsys.com/context/ -Original Message- [EMAIL PROTECTED] Sent: 03 April 2002 14:48 To: Multiple recipients of list ORACLE-L It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list ORACLE-L Sent by: root[EMAIL PROTECTED] cc: Subject: Re: Dynamic create and execute 04/02/2002 procedure 06:28 PM Please respond to ORACLE-L What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Bernard, Gilbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30/03/2002 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Dynamic create and execute procedure I need to create a generic dynamic procedure to create and execute any procedure I wish. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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
Re: Help needed
Give each partition its own tablespace and back up the tablespaces. --- rakesh banerjee [EMAIL PROTECTED] wrote: HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help needed
Rakesh, Yes. You can certainly export a single partition at a time for logical backups. If you put each partition in its own tablespace, you can physically back up individual partions as well. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- banerjee Sent: Wednesday, April 03, 2002 8:18 AM To: Multiple recipients of list ORACLE-L HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee -- Author: rakesh banerjee INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com which details all variations, restrictions, and abilities of the connect command. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: sysdba i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Pinhitratio vs gethitratio
Can someone explain why a pinhitratio would be higher than a gethitratio in the v$librarycache for the namespace = 'SQL AREA'? I would think it would be the opposite. Our current gethitratio is 87.98 and the pinhitratio is 95.10. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help needed
Rakesh, Keep in mind the init parameter MAXDATAFILES when you initially build your database. If the original database was built with a small limit then you will have to rebuild to change the MAXDATAFILES parameter. Search the metaslink site for information on changing the parameter if you think you will need to increase it. ROR mª¿ªm [EMAIL PROTECTED] 04/03/02 09:53AM Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: SQL Server vs. Oracle 9i
Consider the source. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 10:03 AM Subject: SQL Server vs. Oracle 9i This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
RE: Creating staging area from Windows client
I did consider the download option but the part number differs from the CD I have in my hand and I'm not sure whether this reflects the different method of delivery or a slightly different build. Cheers, Mike -Original Message- Sent: 03 April 2002 16:54 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I have always had access to a local Unix box, inserted and tar'ed the CD's there. If you can't do the same, then go to otn.oracle.com and download it (http://download.oracle.com/otn/solaris/817/817solaris.cpio.gz) Brian P. MacLean Oracle DBA, OCP8i Hately Mike Mike.Hately@chur To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] chill.com cc: Sent by:Subject: Creating staging area from Windows client [EMAIL PROTECTED] 04/03/02 01:48 AM Please respond to ORACLE-L All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help needed
Hi, Thanks for ur answer. Can u please help me in giving the code about how to implement it, i.e. how to write the code specifying the particular tablespace, because as the new financial year will appear, new tablespace will be required. So how it can be managed to put the code in the DDL script so that it assigns the tablespace automatically. Waiting for ur reply. With Regards Rakesh Banerjee From: Igor Neyman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Help needed Date: Wed, 03 Apr 2002 06:53:33 -0800 Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Slightly OT: Perl Q.
Lets see the script. Are you sure you are setting the environment variables? Are the scripts being run by the same username? Why don't you set the environment variables in the perl script? On Wed, 3 Apr 2002, 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8.0.5 -- 8.1.7 apps upgrade
That's what it is looking like I have to do. Since we are moving the database to a new server, I was trying to save a step if possible. Thanks. John -Original Message- Sent: Wednesday, April 03, 2002 9:58 AM To: Multiple recipients of list ORACLE-L How about installing 8.1.7 on your NT server and migrating the database on it's current server? You need the 8.0.5 software to do the migration. The 8.1.7 mig utility is actually placed in the 8.0.5 ORACLE_HOME. Jared On Tuesday 02 April 2002 14:05, Fedock, John (KAM.RHQ) wrote: Looking into how to do this. The 8.0.5 database is on NT. The 8.1.7 is on Windows2000. I thought I could: - shut down database on 8.0.5 (on NT) - copy datafiles to windows 2000 server. - start 8.1.7 service on windows2000 server - run cat08005.sql scripts on windows2000 server - finish other tasks This way I could move the database and upgrade in 1 step. Oracle is saying I cannot do it this way. They are stating I must Migrate the Database from 805 to 817 on a Supported Platform and THEN move the database from one machine to another. To do this, I will then have to install 8.1.7 on my current production server (NT), do the upgrade and then move the database to the new windows2000 server. Is there a better way? Thanks in advance. John Fedock K Line America, Inc. [EMAIL PROTECTED] www.kline.com -- 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: Fedock, John (KAM.RHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL Server vs. Oracle 9i
I bet following variable is set in the test _ignore_downtime_cost=true; _ignore_reboots_cost=true; Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: Slightly OT: Perl Q.
You didn't specify the shell you are using but because of the . file syntax I'll ass|u|me you are using sh or ksh. I will also ass|u|me you have the correct perl code. It would have been nice if you included an example of your setup code and perl code butoh well. The correct way to set up environment variables (for the shells I have used) so that child process can see a variable is: csh - setenv MY_VAR value sh - MY_VAR=value; export MY_VAR ksh - export MY_VAR=value Once you think you have the variables set the easiest way to check if they are propagated to child processes is to start a sub-shell and have it echo the variables like so: oracle MY_VAR1=var1_value oracle export MY_VAR2=var2_value oracle echo MY_VAR1=${MY_VAR1} MY_VAR2=${MY_VAR2} MY_VAR1=var1_value MY_VAR2=var2_value oracle ksh -c 'echo MY_VAR1=${MY_VAR1} MY_VAR2=${MY_VAR2}' MY_VAR1= MY_VAR2=var2_value oracle I'm not a big perl person but here is a perl example: oracle MY_VAR1=var1_value oracle export MY_VAR2=var2_value oracle /tmp/env.pl | grep MY MY_VAR2 = var2_value oracle export MY_VAR1 oracle /tmp/env.pl | grep MY MY_VAR1 = var1_value MY_VAR2 = var2_value oracle cat /tmp/env.pl #!/usr/local/bin/perl foreach $key (sort keys(%ENV)) { print $key = $ENV{$key}\n; } oracle Brian P. MacLean Oracle DBA, OCP8i Jack van Zanen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: L Subject: Slightly OT: Perl Q. Sent by: [EMAIL PROTECTED] om 04/03/02 01:53 AM Please respond to ORACLE-L 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
Re: Slightly OT: Perl Q.
-- Jack van Zanen [EMAIL PROTECTED] 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 Not very descriptinve, but obvious things to check are that the variables are exported and the perl code is forked w/in the shell that set the var's. You'll generally find it less effort to set %ENV in the perl code that then shell. Puts all the issues in one place, and you have better logic in perl anyway. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Literal SQL and sys.dual
TRy something like this ... CREATE OR REPLACE PACKAGE My_Dynamic_Stuff IS v_result NUMBER; -- PROCEDURE eval_this (pi_string IN VARCHAR2); END My_Dynamic_Stuff; / CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN RTRIM(pi_string,';') || '; end;'; END eval_this; -- END My_Dynamic_Stuff; / Here is a test ... SQL get raj_test 1 declare 2my_str varchar2(100); 3 begin 4 dbms_output.enable; 5 my_dynamic_stuff.eval_this('1 + 1 + 1 + 1'); 6 dbms_output.put_line ('1 + 1 + 1 + 1 evaluates to : ' || to_char(my_dynamic_stuff.v_result)); 7 -- 8 my_dynamic_stuff.eval_this('1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0)'); 9 dbms_output.put_line ('1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0) evaluates to : ' || to_char(my_dynamic_stuff.v_result)); 10* end; SQL raj_test 1 + 1 + 1 + 1 evaluates to : 4 1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0) evaluates to : 3.3 PL/SQL procedure successfully completed. SQL HTH some Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: SQL Server vs. Oracle 9i
yeah but it was written by MS. [EMAIL PROTECTED] 04/03/02 10:03AM This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM -- 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).
Re: Creating staging area from Windows client
I have always had access to a local Unix box, inserted and tar'ed the CD's there. If you can't do the same, then go to otn.oracle.com and download it (http://download.oracle.com/otn/solaris/817/817solaris.cpio.gz) Brian P. MacLean Oracle DBA, OCP8i Hately Mike Mike.Hately@chur To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] chill.com cc: Sent by:Subject: Creating staging area from Windows client [EMAIL PROTECTED] 04/03/02 01:48 AM Please respond to ORACLE-L All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP client and when I copy the software across runInstaller fails. I believe it's a problem with Windows' handling of the executable bit. Can anyone suggest a workaround for this? Cheers, Mike Hately This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Connecting to Oracle via Perl
-- [EMAIL PROTECTED] Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is appreciated? I do not have any kind of password server. If you use shell-based authentication then you can connect via DBI and DBD::Oracle with: my $dbh = DBI-connect( dbi:Oracle:$db, '', '' ); (i.e., empty string for both user and pass). $db would be the tns name for whatever you're connecting to (see the DBD::Oracle manpages for examples). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: max_open_cursors
Hi All, max_open_cursors of 2000? What programmer can handle 2000 open cursors at once? Remember this is per session. The default is 40, if a programmer can explain to me the cursors he has to maintain open, and that number is 40 then I will increase the number to 100. This has happened to me once in 10 years DBAing (and the programmer was one of these brilliant people where I just nod my head in awe when he speaks :) 2000 open cursors is a code problem. Happens alot in JAVA where they will not finish/close their result set. Dave Mogens wrote: It can be set to much higher values if the need is there. There used to be some kind of limit depending on the various 7-versions as far as I remember. Personally, I haven't seen the need for anything higher than 2000 more than once or twice. -- 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: SQL Server vs. Oracle 9i
The Walklett Group, the author of the paper cited, is a consulting/services company and has Microsoft listed on their "Alliances" web page, although the exact nature of the relationship is not defined. The paper makes a number of assumptions that I would question. After reading it, I do not find it to be a persuasive arguement in favor of the solution recommended (microsoft SQL Server on a Unisys box). read the white paper for yourself at http://www.microsoft.com/sql/evaluation/compare/WalklettAnalysis.pdf Matt Adams - GE Appliances - [EMAIL PROTECTED]If C gives you engouth rope to hang yourself, then C++ givesyou enough rope to hang yourself, your dog, your co-workers,and everyone in your neighborhood. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 03, 2002 10:04 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server vs. Oracle 9i This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
RE: RE: License standby database?
Gene, HA means High Avalability. HA is a DB Server waiting to become the prod DB via shared storage, Not really. You can implement HA by any means as long as you ensure you have High Availability. IMHO standby is also something that is waiting to be activated and to become prod server. Actually standby is normally a better HA because shared disks would not protect you from disks going south. The point under discussion here, since you have missed it, is whether standby could be considered oracle running on standby host. ORACLE reps went on record saying that you con not since the oracle running on other server is in managed recovery mode. HTH Cheers, RS --- Gene Sais [EMAIL PROTECTED] wrote: HA is different from Standby. Standby is an Oracle DB in recovery, i.e. Oracle running on 2 servers. HA is a DB Server waiting to become the prod DB via shared storage, i.e. Oracle running on 1 server. [EMAIL PROTECTED] 04/03/02 09:28AM Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- Post, Ethan [EMAIL PROTECTED] wrote: Not sure this is correct Rachel. I sat in a conference call today with some folks and an Oracle rep and it was stated that any type of HA software being used would require additional licenses for the all possible servers in the failover cluster. So even if Oracle is not running on server B until A fails I would need a license for B. Of course the whole reason for the call was to discuss Oracles evolving licensing model. Can anyone else confirm or deny? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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).
RE: Trouble ticketing system
Hi David, Look into REQUEST TRACKER. Open source (perl), many databases. Similar to Remedy byt free. A Google search will find it. Why code when you can install? 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: SQL Server vs. Oracle 9i
But a clueless CIO or IT Director might be persuaded...and that is the problem. Even more so, when the IT budget is tight...and when is the IT budget not tight?? -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 03, 2002 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SQL Server vs. Oracle 9i The Walklett Group, the author of the paper cited, is a consulting/services company and has Microsoft listed on their "Alliances" web page, although the exact nature of the relationship is not defined. The paper makes a number of assumptions that I would question. After reading it, I do not find it to be a persuasive arguement in favor of the solution recommended (microsoft SQL Server on a Unisys box). read the white paper for yourself at http://www.microsoft.com/sql/evaluation/compare/WalklettAnalysis.pdf Matt Adams - GE Appliances - [EMAIL PROTECTED]If C gives you engouth rope to hang yourself, then C++ givesyou enough rope to hang yourself, your dog, your co-workers,and everyone in your neighborhood. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 03, 2002 10:04 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server vs. Oracle 9i This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
Re: SQL Server vs. Oracle 9i
And I charge less than Steve Adams or Jonathan Lewis (3.5 times lesser), for 'comparable' features (could be physical). So, hire me, and Save a million in 5 years. Who buys that? ;-) Raj Gene Sais [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ach.fl.us cc: Sent by: Subject: Re: SQL Server vs. Oracle 9i [EMAIL PROTECTED] April 03, 2002 10:53 AM Please respond to ORACLE-L yeah but it was written by MS. [EMAIL PROTECTED] 04/03/02 10:03AM This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM -- 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).
ORA-00600 error
Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tech.gif Description: GIF image
DBA's supporting CERNER
DBA's, If there are any DBA's on the list supporting CERNER medical applications please contact me off list. We are in the decision/planning stages of aquiring this product and I would like to get some advise on how much care and feeding this beast requires. Thanks Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EMC question
I don't want to start a technical religious war here. Nevertheles, I am not a great fan of raw devices especially after the advent of comparable I/O options such as Direct I/O within Oracle which allows you to keep your file system layout and yet have raw device comparable performance. Plus options such as Quick I/O and Cached Quick I/O from Veritas provide similar performance and ease of maintenance and management. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: So it's great that EMC is offering striping on the hardware level that should be good idea for implementing striped raw device. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/2/02 6:28 PM Hi Waleed list, The issue I raised about queuing was within the context of sequential writes to the various stripe units within a striped volume. If you have a 4-way stripe and there are 4 dirty disk blocks (1 on each stripe unit) that needs to be written to each of the 4 disks, the LVM-mid-layer should be able to get them down to their respective disks, independent of one another, not one after the other. If the dirty disk blocks are not written independent of one another, there will be no advantage of striping for writes. And pure striping should cater to I/O scalability for both reads and writes. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: HI Gaja list, I am trying to find the truth here! I was told by the storage group that EMC has striping now and this what I'm researching. Gaja, what you described as a problem during WRITES to striped EMC is a typical procedure in any striped volumes. There is a mid layer that has to map logical I/O addresses to physical disk addresses. If you are using Veritas LVM then all reads/writes requests will be queued to the LVM and will do exactly as you mentioned. There is a queue but the difference is big. You have a queue with many servers serving the queue requests simultaneously. Please check powerlink.emc.com Regards, Waleed -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38
Re: Help needed
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Join the worldÆs largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---Received: from CONNECT-MTA by galottery- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00600 error
Bunyamin, I think you better check the following doc. from metalink... START * Doc ID: Note:31056.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 31-DEC-1996 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [729], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [729][a][b][c][d][e] VERSIONS: versions 7.X to 8.X DESCRIPTION: A space leak has been detected in the User Global Area (UGA). There is NO data corruption as a result of this error. It is an internal memory housekeeping problem. ARGUMENTS: Arg [a] This is the number of bytes leaked FUNCTIONALITY: MEMORY COMPONENT IMPACT: PROCESS FAILURE - But only during logoff so impact is minimal. NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: Event 10262 can be set to safely ignore small memory leaks. Set the following in init.ora for example to disable space leaks less than 4000 bytes: event = 10262 trace name context forever, level 4000 and stop and restart the database. Repeated errors or large memory leaks can be diagnosed further by sending the alert.log and trace files to Oracle support. Known Issues: Bug 2177050: ORA-600 [729] after application of the 8.1.7.3 patchset The resulting trace file will include a memory dump which shows unfreed memory chunks with the tags define var info and/or oactoid info. Workaround: Set EVENT 10262 with a LEVEL greater than the reported leak. A value of 100Kb (102400) is a reasonable limit. Fixed in 8.1.7.4 and 9.X releases. One-off patches are available for most platforms. . ** END HTH RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002 Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC: ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 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. ATTACHMENT part 2 image/gif name=dbainblk.gif The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. ATTACHMENT part 4 image/gif name=tech.gif __ 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: RMAN
Dave, I never said setup was easy. I agree that getting the tape software integrated can be a real pain in the side, depending on what vendor you use (DON'T USE CA'S ARCSERVE) As far as backup goes, this is my command for full database backup. Much simpler than strategies I've had to use in the past: run { allocate channel tape1 type 'sbt_tape' format '%d_%s_%p_%t.rman'; backup database tag='full_db_backup' setsize 500; } Since I don't have the luxury of a catalog database at my disposal, I can't store scripts so my alter system archive log all statement, backup archivelogs and controlfile are separate run statements. Here's the simplest part. I have tested recovery from several scenarios with just the following commands: restore database; recover database; and watched rman bring back the necessary archive logs and database files. Now that is simple if you ask me, especially if I happen to be half-asleep when I need to do this. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Dave Morgan [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Hi Lisa, RMAN easy? ROTFL ksh scripts, 5 minutes to adjust environment variables done RMAN, let see create a seperate database, set up RMAN, oh, then I have to set up RMAN in the production db to protect my RMAN db Oh and then shall we integrate Legato or NetBackup. 2 days minimum. Having said this, remember, who needs backups? We just need recoveries. I use RMAN, I just don't trust it. I have had situations (8.0.5) where I could not recover with RMAN but could with the backups from scripts RMAN and OEM belong in the same place, the garbage Long live vi, ksh/sh/bash and sqlplus Dave Lisa wrote: Gene's afraid of R-Man! Gene's afraid of R-Man! Gene you will not believe how simple RMAN is once you start using it... -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EMC question
No wars! I also agree there are good products out there. But the question will be: can these products offer striping for Oracle OPS/RAC? Using EMC striping would allow this, I believe! note: I'm not working for EMC Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, April 03, 2002 12:41 PM To: Multiple recipients of list ORACLE-L I don't want to start a technical religious war here. Nevertheles, I am not a great fan of raw devices especially after the advent of comparable I/O options such as Direct I/O within Oracle which allows you to keep your file system layout and yet have raw device comparable performance. Plus options such as Quick I/O and Cached Quick I/O from Veritas provide similar performance and ease of maintenance and management. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: So it's great that EMC is offering striping on the hardware level that should be good idea for implementing striped raw device. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/2/02 6:28 PM Hi Waleed list, The issue I raised about queuing was within the context of sequential writes to the various stripe units within a striped volume. If you have a 4-way stripe and there are 4 dirty disk blocks (1 on each stripe unit) that needs to be written to each of the 4 disks, the LVM-mid-layer should be able to get them down to their respective disks, independent of one another, not one after the other. If the dirty disk blocks are not written independent of one another, there will be no advantage of striping for writes. And pure striping should cater to I/O scalability for both reads and writes. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: HI Gaja list, I am trying to find the truth here! I was told by the storage group that EMC has striping now and this what I'm researching. Gaja, what you described as a problem during WRITES to striped EMC is a typical procedure in any striped volumes. There is a mid layer that has to map logical I/O addresses to physical disk addresses. If you are using Veritas LVM then all reads/writes requests will be queued to the LVM and will do exactly as you mentioned. There is a queue but the difference is big. You have a queue with many servers serving the queue requests simultaneously. Please check powerlink.emc.com Regards, Waleed -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL
[Fwd: ORA-00600 error]
Bünyamin, The trace you sent is not enough. But before determining if your memory is enough or not, we should understand if the requested memory size is normal or if UGA shrinks normally . For quick answer: Check session uga memory and session uga memory max statistics. can you attache the trace file ? regards... -- Danisment Gazi Unal http://www.unal-bilisim.com ---BeginMessage--- Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tech.gif Description: GIF image ---End Message---
RE: Insert statement hangs
If you have the Diagnostics Pack, try looking at your session in Top Sessions. Beth -Original Message- Sent: Wednesday, April 03, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am trying to insert a record thru sql*plus into a table. I am the only one accessing database. It just hangs and never inserts. What I can I look at to help determine why this is happening? Thanks Rick -- 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Insert statement hangs
Rick , check logfiles May be ur database is running in archivelog and archive destinations are full . There are many other possible reasons ..look into alertSID.log for them . -Bigp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 10:06 AM Hi DBAs, I am trying to insert a record thru sql*plus into a table. I am the only one accessing database. It just hangs and never inserts. What I can I look at to help determine why this is happening? Thanks Rick -- 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: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00600 error [729]
Is any of export(exp) job is being terminated abruptly? This is the main reason for this message. It was corrected in ver 7.3.4.5. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 03 Apr 2002 10:06:18 -0800 Bunyamin, I think you better check the following doc. from metalink... START * Doc ID: Note:31056.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 31-DEC-1996 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [729], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [729][a][b][c][d][e] VERSIONS: versions 7.X to 8.X DESCRIPTION: A space leak has been detected in the User Global Area (UGA). There is NO data corruption as a result of this error. It is an internal memory housekeeping problem. ARGUMENTS: Arg [a] This is the number of bytes leaked FUNCTIONALITY: MEMORY COMPONENT IMPACT: PROCESS FAILURE - But only during logoff so impact is minimal. NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: Event 10262 can be set to safely ignore small memory leaks. Set the following in init.ora for example to disable space leaks less than 4000 bytes: event = 10262 trace name context forever, level 4000 and stop and restart the database. Repeated errors or large memory leaks can be diagnosed further by sending the alert.log and trace files to Oracle support. Known Issues: Bug 2177050: ORA-600 [729] after application of the 8.1.7.3 patchset The resulting trace file will include a memory dump which shows unfreed memory chunks with the tags define var info and/or oactoid info. Workaround: Set EVENT 10262 with a LEVEL greater than the reported leak. A value of 100Kb (102400) is a reasonable limit. Fixed in 8.1.7.4 and 9.X releases. One-off patches are available for most platforms. . ** END HTH RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002 Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC: ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 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. ATTACHMENT part 2 image/gif name=dbainblk.gif The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. ATTACHMENT part 4 image/gif name=tech.gif __ 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: Help needed
Rakesh , create your tablespaces as required using system managed or LMT's. I chose LMT and I wanted to control the size of the extents. example: CREATE TABLESPACE IDSR_DATA_02 DATAFILE '/data3/lnxdb/idsr02d.dbf' SIZE 1600 M AUTOEXTEND ON NEXT 20 M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20 M; CREATE TABLESPACE IDSR_INDX_93 DATAFILE '/indx1/lnxdb/idsr93i.dbf' SIZE 12 M AUTOEXTEND ON NEXT 2 M NOLOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2 M; Then you create the tables for the tablespaces. Example: CREATE TABLE GLCIDSR ( SALEDATE DATE, additional columns...) PARTITION BY RANGE(SALEDATE) (PARTITION IDSRD93 VALUES LESS THAN ('01-01-1994') TABLESPACE IDSR_DATA_93, PARTITION IDSRD94 VALUES LESS THAN ('01-01-1995') TABLESPACE IDSR_DATA_94, Then create the indexes for the tables. Example. ALTER TABLE glcidsr ADD CONSTRAINT glcidsr_pk PRIMARY KEY ( saledate) USING INDEX local (partition idsr93 tablespace idsr_indx_93 storage (initial 1 M next 1 M pctincrease 0), partition idsr94 tablespace idsr_indx_94 storage (initial 2 M next 2 M pctincrease 0),... There is very good documentation available on using these features that Oracle has developed. Remember that some of the features must be purchased if used in a business. ROR mª¿ªm [EMAIL PROTECTED] 04/03/02 10:33AM Hi, Thanks for ur answer. Can u please help me in giving the code about how to implement it, i.e. how to write the code specifying the particular tablespace, because as the new financial year will appear, new tablespace will be required. So how it can be managed to put the code in the DDL script so that it assigns the tablespace automatically. Waiting for ur reply. With Regards Rakesh Banerjee From: Igor Neyman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Help needed Date: Wed, 03 Apr 2002 06:53:33 -0800 Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Join the worldÆs largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Follow-up :Long running SQL Problem?
CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, My senior DBA always tell us that the not in command sucks and we are all encourage to use the select count(*). SQL A is greatly frowned upon and SQL B will be the best. SQL A : SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2 WHERE col3 = col1 AND col4 = col2); SQL B : SELECT col1,col2 FROM Table_1 A WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND b.col4=a.col2)); Qn : Is it true ? Could someone shed some light ? Please advise. Thanks. Regds, Catherine Larry has pointed to me off-list that your 'SQL A' query is indeed correlated - totally unusual for a 'NOT IN' and, in your case, such a case for disaster (couldn't return anything) that I presume that you typed it as fast as I read it initially? Being as lazy as he is :-) here is from Larry's message : Also, point her towards Metalink note 28934.1. It contains a good discussion. But I don't agree with the final conclusion to always use NOT EXISTS even though a NOT IN using a HASH AJ is sometimes much better. The only reason for that recommendation was their fear that many folks don't understand how a NOT IN handles nulls in the results set (returns no rows) differently than a NOT EXISTS. A good developer should know the difference. HTH, 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: EMC question
Hello, If you want to use OPS/RAC, I suggest you go with something like an HP-256 disk array (or bigger, depending on your needs; a 256 is good for 1-2 terabytes and can be easily increased); and use mirroring and business copies. Caveat to the above: this is only good for read-intensive, not write-intensive. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 03, 2002 1:33 PM To: Multiple recipients of list ORACLE-L No wars! I also agree there are good products out there. But the question will be: can these products offer striping for Oracle OPS/RAC? Using EMC striping would allow this, I believe! note: I'm not working for EMC Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, April 03, 2002 12:41 PM To: Multiple recipients of list ORACLE-L I don't want to start a technical religious war here. Nevertheles, I am not a great fan of raw devices especially after the advent of comparable I/O options such as Direct I/O within Oracle which allows you to keep your file system layout and yet have raw device comparable performance. Plus options such as Quick I/O and Cached Quick I/O from Veritas provide similar performance and ease of maintenance and management. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: So it's great that EMC is offering striping on the hardware level that should be good idea for implementing striped raw device. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/2/02 6:28 PM Hi Waleed list, The issue I raised about queuing was within the context of sequential writes to the various stripe units within a striped volume. If you have a 4-way stripe and there are 4 dirty disk blocks (1 on each stripe unit) that needs to be written to each of the 4 disks, the LVM-mid-layer should be able to get them down to their respective disks, independent of one another, not one after the other. If the dirty disk blocks are not written independent of one another, there will be no advantage of striping for writes. And pure striping should cater to I/O scalability for both reads and writes. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: HI Gaja list, I am trying to find the truth here! I was told by the storage group that EMC has striping now and this what I'm researching. Gaja, what you described as a problem during WRITES to striped EMC is a typical procedure in any striped volumes. There is a mid layer that has to map logical I/O addresses to physical disk addresses. If you are using Veritas LVM then all reads/writes requests will be queued to the LVM and will do exactly as you mentioned. There is a queue but the difference is big. You have a queue with many servers serving the queue requests simultaneously. Please check powerlink.emc.com Regards, Waleed -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is
RE: RMAN
I used to be a hot backup scripter hack like Dave :-) but now I've been backing up... AND RECOVERING with RMAN for a few years. Setup is the most difficult part but after several times now I'm starting to get the hang of it. You can use the sbttest utility without having to relink Oracle so you can test (partially) the MML before doing RMAN. I tend to think that doing an RMAN restore database validate is not enough... I like to actually restore a datafile before I pronounce the backup ready for prime time. I just did that about 30 minutes ago on a RMAN tape backup for a new server. The troubleshooting chapter in the RMAN manual is pretty good but it's 35 pages so that confirms that setup can be an ordeal. Steve Orr Bozeman, MT -Original Message- Sent: Wednesday, April 03, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Dave, I never said setup was easy. I agree that getting the tape software integrated can be a real pain in the side, depending on what vendor you use (DON'T USE CA'S ARCSERVE) As far as backup goes, this is my command for full database backup. Much simpler than strategies I've had to use in the past: run { allocate channel tape1 type 'sbt_tape' format '%d_%s_%p_%t.rman'; backup database tag='full_db_backup' setsize 500; } Since I don't have the luxury of a catalog database at my disposal, I can't store scripts so my alter system archive log all statement, backup archivelogs and controlfile are separate run statements. Here's the simplest part. I have tested recovery from several scenarios with just the following commands: restore database; recover database; and watched rman bring back the necessary archive logs and database files. Now that is simple if you ask me, especially if I happen to be half-asleep when I need to do this. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Dave Morgan [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Hi Lisa, RMAN easy? ROTFL ksh scripts, 5 minutes to adjust environment variables done RMAN, let see create a seperate database, set up RMAN, oh, then I have to set up RMAN in the production db to protect my RMAN db Oh and then shall we integrate Legato or NetBackup. 2 days minimum. Having said this, remember, who needs backups? We just need recoveries. I use RMAN, I just don't trust it. I have had situations (8.0.5) where I could not recover with RMAN but could with the backups from scripts RMAN and OEM belong in the same place, the garbage Long live vi, ksh/sh/bash and sqlplus Dave -- 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: Literal SQL and sys.dual
Thanks a million, I am going to try it and let you know how it works out. I can see the result I am looking for. Shakir --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: TRy something like this ... CREATE OR REPLACE PACKAGE My_Dynamic_Stuff IS v_result NUMBER; -- PROCEDURE eval_this (pi_string IN VARCHAR2); END My_Dynamic_Stuff; / CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN RTRIM(pi_string,';') || '; end;'; END eval_this; -- END My_Dynamic_Stuff; / Here is a test ... SQL get raj_test 1 declare 2my_str varchar2(100); 3 begin 4 dbms_output.enable; 5 my_dynamic_stuff.eval_this('1 + 1 + 1 + 1'); 6 dbms_output.put_line ('1 + 1 + 1 + 1 evaluates to : ' || to_char(my_dynamic_stuff.v_result)); 7 -- 8 my_dynamic_stuff.eval_this('1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0)'); 9 dbms_output.put_line ('1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0) evaluates to : ' || to_char(my_dynamic_stuff.v_result)); 10* end; SQL @raj_test 1 + 1 + 1 + 1 evaluates to : 4 1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0) evaluates to : 3.3 PL/SQL procedure successfully completed. SQL HTH some Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ 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: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help needed
help received... I was responding to the question about the tablespace partitioning with text and examples. My email package (groupwise) is still randomly limiting the size of the emails. Thanks for helping. Ron [EMAIL PROTECTED] 04/03/02 01:43PM Help given -Original Message- Sent: Wednesday, April 03, 2002 12:06 PM To: Multiple recipients of list ORACLE-L To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Join the worldÆs largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---Received: from CONNECT-MTA by galottery- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). -- 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: SQL Server vs. Oracle 9i
It's fascinating when somebody proclaims "50% savings in TCO over a 5 year period" when it is patently obvious that A)such aconfiguration has not existed over the past five years and B) it will never exist over any contiguous five year period. The lifecycle of systems doesn't happen that way. Back in the 1980s when the US space shuttle "Challenger" explosion was being investigated by a panel of eminent politicians, lawyers, and scientists, Nobel-laureate physicist Richard Feynmannsingled outNASA testimony stating that the "Challenger" explosion could only happen in 1 out of 100,000 launches. Noting that US space shuttles had been launchedabout 50-60 times up to that point, he asked how anyone could possiblyproject odds of "1 out of 100,000", never mind try to pass it off as "fact". When I read about TCO on a configurationgoing forward5 years, I wonder if those people are on-call and wearing pagers, or whether they know anybody who is... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 8:03 AM Subject: SQL Server vs. Oracle 9i This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
RE: Literal SQL and sys.dual
Hmmm there is a small error The package body should be as follows CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN RTRIM(pi_string,';') || '; end;'; END eval_this; -- END My_Dynamic_Stuff; / this of course assumes that you are on 8i or better version, if you are on pre 8i version, change code appropriately to use dbms_sql package instead of NDS. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Help needed
Rakesh, Keep in mind the init parameter MAXDATAFILES when you initially build your database. If the original database was built with a small limit then you will have to rebuild to change the MAXDATAFILES parameter. Search the metaslink site for information on changing the parameter if you think you will need to increase it. ROR mª¿ªm [EMAIL PROTECTED] 04/03/02 09:53AM Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS (i.e. OF THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your reply at the earliest, as my design will be dependent on your feedback. With Regards Rakesh Banerjee _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rakesh banerjee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: Do programmers tune SQL?
Thanks to everyone that replied to this question. I feel that I have a MUCH more well-rounded view of how this works at other organizations, and where the pitfalls are. I am going to develop a document for the developers that outlines how I see this working. I will share it with the list when I complete it. Thanks again. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 01, 2002 7:48 PM To: Multiple recipients of list ORACLE-L There was one guy at a site I used to work for that was interesting. He wrote his own shell scripts and PL/SQL routines and did them well. He was open to learning and all that good stuff. However, he felt that it was the sys. admin's job to write the shell scripts and the DBA's to write the PL/SQL (not the SQL). Its like ya, you want me to write your Java and C code also? Just a funny mix -Original Message- Faroult Sent: Monday, April 01, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Rachel Carmichael wrote: My last shop we had one programmer who not only expected me to tune his SQL, he expected me to WRITE his SQL for me. I got emails I need a query that returns this information from these tables. This guy seems to be trying a new tactic these days: DBA mailing lists. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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).
RMAN Core dumps while restoring datafile
Greetings all, I was trying restore one data file but it core dumps. Following is the log file but didnot specify any error. Any idea. Thanks, Ashoke unix Segmentation Fault - core dumped Recovery Manager: Release 8.1.7.0.0 - Production RMAN-06005: connected to target database: PTESTAKM (DBID=1408056539) RMAN-06008: connected to recovery catalog database RMAN run { 2 allocate channel t1 type 'SBT_TAPE' 3 parms 'ENV=(NSR_SERVER=torra.pace.medtronic.com)'; 4 5 sql alter tablespace USERS offline immediate; 6 7 restore datafile '/u02/oradata/ptestakm/users01.dbf'; 8 recover datafile '/u02/oradata/ptestakm/users01.dbf'; 9 10 sql alter tablespace USERS online; 11} 12 13 RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: t1 RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE RMAN-08526: channel t1: BMO v3.0 RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter tablespace USERS offline immediate RMAN-03023: executing command: sql RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel t1: starting datafile backupset restore RMAN-08502: set_count=128 set_stamp=458229797 creation_time=Apr 03 2002 14:03:17 RMAN-08089: channel t1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 4 to /u02/oradata/ptestakm/users01.dbf RMAN-08023: channel t1: restored backup piece 1 RMAN-08511: piece handle=full_PTESTAKM_128_458229797_40dl0215 tag=FULL_PTESTAKM_BACKUP params=NULL RMAN-08024: channel t1: restore complete RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-03022: compiling command: recover(4) RMAN-03023: executing command: recover(4) RMAN-08017: channel t1: starting archivelog restore to default destination RMAN-08022: channel t1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
The solution of adding a column es very good, but you can create a table to keep the closed tickets(deleted) and if you want to reopen it, just look it in that table and recreate it. Assuming that the quantity of reopened tickets is small this will work for you Luck -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Post, Ethan [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 5:08 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:RE: Ticket tracking system Manager to David... David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true? ok enough of that let's ponder some possible solutions... 1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it. 2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database. 3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket. 4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement. - Ethan -Original Message- Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
DB Trigger to control PK change
Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing. TIA Ramon E. Estevez -- 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: DB Trigger to control PK change
As opposed to using auditing? What version of Oracle? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Subject: DB Trigger to control PK change Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing. 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).
Re: SQL Server vs. Oracle 9i
Hi Tim, Nice to see you here -bill At 01:03 PM 4/3/2002 -0800, you wrote: It's fascinating when somebody proclaims 50% savings in TCO over a 5 year period when it is patently obvious that A) such a configuration has not existed over the past five years and B) it will never exist over any contiguous five year period. The lifecycle of systems doesn't happen that way. Back in the 1980s when the US space shuttle Challenger explosion was being investigated by a panel of eminent politicians, lawyers, and scientists, Nobel-laureate physicist Richard Feynmann singled out NASA testimony stating that the Challenger explosion could only happen in 1 out of 100,000 launches. Noting that US space shuttles had been launched about 50-60 times up to that point, he asked how anyone could possibly project odds of 1 out of 100,000, never mind try to pass it off as fact. When I read about TCO on a configuration going forward 5 years, I wonder if those people are on-call and wearing pagers, or whether they know anybody who is... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 8:03 AM Subject: SQL Server vs. Oracle 9i This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM
RE: DB Trigger to control PK change
I am not sure there is a trigger to do that Ramon. Why not use the audit option to track changes. John -Original Message- [EMAIL PROTECTED] Sent: 03 April 2002 22:33 To: Multiple recipients of list ORACLE-L Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing. TIA Ramon E. Estevez -- 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: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
i did use the oracle account with primary group as oinstall and secondary as dba. this what the manual tells. [EMAIL PROTECTED] wrote: That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com which details all variations, restrictions, and abilities of the connect command. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: sysdba i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asia Town I.T. Park Lahug, Cebu City 6000, Philippines Office : +63(32)233-9142 Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email: [EMAIL PROTECTED] I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
help - JVM on Oracle
Hello List: I have Oracle 8.1.7 installed. It has includes a fully functional Java virtual machine (VM), as well as the Java class libraries for Sun's Java Development Kit (JDK) 1.2.1. , as readme.txt file states. Locally, I also have jdk1.3.1 installed. You can see this 2 JVM does not match. Im wondering, can JUST Oracles JVM gets upgrade? If yes, how? Here is the reason that I brought up this issue: Im passing Java returns value to Oracle, Time Zone, specifically. However, the value I can see from Java will get cut when pass to Oracle. For example: from Java session, I have a value America/Chicago, but when return from Oracle SQL session, I got CST. I want my complete original string, but not the short converted code! There are 2 reasons that I can think of: 1/ The JVMs do not match each other. 2/ Oracle 8i cannot recognize the string. I dont see the reason for this. (I understand that Oracle 8i only support several time zones, but I'm passing a string to Oracle here.) Any idea? Thanks __ 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: Steven Joshua INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
the acoount that i used was oracle account. primary group is oinstall and secondary is dba. bill thater wrote: [EMAIL PROTECTED] wrote: i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. are you starting sqlplus from an account in the DBA group? is the DBA group the primary group? -- -- 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. Youth and skill are no match for experience and treachery. -- 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: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
guess i missed that somewhere, i've always done dba for both groups , never a problem but that could be since i've been doing oracle since version 5 on msdos. joe paPIpapupapePO wrote: i did use the oracle account with primary group as oinstall and secondary as dba. this what the manual tells. [EMAIL PROTECTED] wrote: That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com which details all variations, restrictions, and abilities of the connect command. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: sysdba i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asia Town I.T. Park Lahug, Cebu City 6000, Philippines Office : +63(32)233-9142 Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email: [EMAIL PROTECTED] I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DB Trigger to control PK change
I am trying to do something similar. I want to trap when new tables and procedures are created so I can issue grants and synonyms. I found in the manual triggers at the schema level but I haven't been able to make them work. From the manual CREATE OR REPLACE TRIGGER On_DDL after DDL ON XYZ.Schema BEGIN ... If anyone has an example of using this type of trigger, I would appreciate some help. I am using 8.1.6.3 and the above is taken from the 8.1.6 manual. Thanks, John [EMAIL PROTECTED] 04/03/02 01:33PM Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing. TIA Ramon E. Estevez -- 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: John Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
another listener.ora
How can I start another listener on same box using another listener.ora file . TIA Bp
RE: Do programmers tune SQL?
Whether a programmer tunes SQL depends on their answer to another question, Does the programmer care about overall application performance? If they do and a significant part of the application involves a database then they need to get on a professional development track to become a Database Programmer just like other programmers may need to become Network Programmers, Real Time Embedded Systems Programmers, Internet Programmers, or, for those old Mainframe heads, Systems Programmers. If they don't want to be bothered with such stuff then they'll remain mere programmers and never progress to Developers, Software Engineers, Systems Analysts, System Architects, and other gods. IMHO :-) Programming for the database in not that much of a specialty and anyone who wants to be a pro should get some solid experience with SQL. If you just read Harrison's book then you may think that SQL tuning is overwhelming but it really doesn't have to be that way. If you were to distill down SQL tuning to the basics then you could create a programmers guide to SQL that would be simple, concise, (less than 10 pages) and easy to understand. I wouldn't expect every programmer to come up with SQL so good that there's no room for improvement but... I do expect them to make an effort. I've seen so much sloppy SQL where it was obvious that all the programmer cared about was getting an expected result set against limited data and then moving on to the next function to program. If someone has good skills for producing efficient C code, then those same skills can easily be applied to SQL... actually SQL is really a lot easier. One approach is to create a database API to centralize all your database calls and avoid embedded SQL scattered throughout the code which is difficult to maintain or tune. With all database calls passing through the API, skilled database programmers can tune database access without breaking the application. But there is a point at which SQL tuning becomes overly obtuse, obscure, or esoteric, especially for Oracle-specific or other database-specific tuning. That's when the DBA comes in. For instance, I think it should be rare that the programmer be concerned with using Oracle hints. The cost based optimizer is getting good enough now that we can rely on it a great deal for providing adequate SQL execution paths... just as long as the SQL isn't sloppy to begin with. If we introduce too many hints or other obscure SQL tuning efforts then we create a maintenance burden because the data changes and today's good SQL statement may become tomorrow's pig. Just today I saw a query with an 11 table join and 3 of the 11 tables referenced were the same table but with different aliases. Not only could this have been down with just one join to that table, some of the other join tables were not needed altogether. On top of that, to limit the size of the result set they were using distinct because they couldn't figure out how to do it otherwise. Ugggh!! That's what happens with a programmer thinks he shouldn't have to be bothered with developing good SQL technique. Steve Orr Bozeman, MT -Original Message- Sent: Monday, April 01, 2002 1:13 PM To: Multiple recipients of list ORACLE-L I think there's a new myth: Programmers should tune SQL. Harrison says his book is for developers, but consider what he actually covers. Chapter 8, Tuning Table Access, covers many topics that are for DBA's, not developers: -- hit rate in the buffer cache -- db_file_multiblock_read_count -- number of blocks used for the table -- size of data blocks -- depth of index -- histograms -- use of ANALYZE and dbms_stats -- subtle points of index creation -- types of indexes, strategies -- fast full index scan -- bitmap_merge_area_size parm -- alter table minimize records_per_block -- setting up hash clusters -- IOT's, configuring the overflow statement -- periodic rebuild of indexes -- fast_full_scan_enabled=true parm -- lowering the high water mark -- optimizing PCTFREE andd PCTUSED That's from just *one* chapter. Oh sure, he also devotes a few pages to avoiding accidental full table scans caused by SQL that disables an index, etc. But how often are developers going to tune SQL by using the rest of the stuff in this chapter? The root problem is, the phrase tune SQL is a myth. Sure the SQL runs slow, then you tune it and it runs faster. But tuning it often requires DBA knowledge, something DBA's may take for granted, but for developers it's a huge area they have no familiarity with at all. There's a specific set of things you can ask developers to do, but there's another set of things that are required and that you can't reasonably ask developers to do. Harrison's idea that you can get developers to tune SQL is a myth. He's really written a DBA book that delves into tuning SQL, which is a reasonable goal. But to do the reverse -- asking a developer to delve into tuning SQL -- means they have to come to grips with DBA topics,