RE: Truncate system tables.
Title: Message I found it under the platform docs: http://download-east.oracle.com/docs/cd/A97688_07/platdocs.htm HTML version: http://download-east.oracle.com/docs/cd/A97688_07/win.903/install/toc.htm PDF version: http://download-east.oracle.com/docs/cd/A97688_07/win.903/install.pdf -- Paul -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Freeman Robert - ILSent: Wednesday, January 08, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system tables. Ok... I've got a copy of 9iAS 9.0.3 for NT I'm wanting to install, but I'll be darned if I can find an install guide anywhere I've looked on OTN and can find an install guide for a SUN and AIX, but no NT. Anyone have any ideas if such a beast exists and if so where? Robert Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.comAuthor of several books you can find on Amazon.com!
Restoring DB from specific RMAN backup set.
How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Restoring DB from specific RMAN backup set.
Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello when you need them :) -- Paul -Original Message- Sent: Thursday, December 19, 2002 2:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if you call Oracle DB2, what do you call DB2? DBA2: DB2. DBA1: ARRRGGH!! ... Paul Heely [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City
RE: iAS 1.0.2.2.2a vs 9iR2 db
You need to set O7_DICTIONARY_ACCESSIBILITY=TRUE in the database. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 11:40 AM To: Multiple recipients of list ORACLE-L I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: iAS 1.0.2.2.2a vs 9iR2 db
Did you apply the 8.1.7.3, I think that's the right one, patch against the iAS home? Not that it helps with your install, but we have iAS 1.0.2.2.2a running with a 9iR2 DB. It was originally installed against 9iR1 and then the DB was upgraded. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 3:21 PM To: Multiple recipients of list ORACLE-L already done. Well, more troubleshooting in order? They also told me iAS 10.2.2.2a is not certified for XP, what a mess. Pat. -Original Message- Sent: Wednesday, December 18, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You need to set O7_DICTIONARY_ACCESSIBILITY=TRUE in the database. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 11:40 AM To: Multiple recipients of list ORACLE-L I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: password
I used to work as a Unix security admin and would frequently run password cracking programs against our password files. We found that the really weak passwords were found in the first 5 minutes, ones derived from info in the gecos fields. Better ones, using number/letter substitutions in common dictionary words, would be found in the next day or so. We stopped running after 48 hours. We never found that brute force iteration was worthwhile. Consider the following if you are thinking of using a totally brute force approach and trying all possible combinations. I needed a break this afternoon... Assumptions: All passwords are 6 characters long and all characters are upper case. There are 6^26=170,581,728,179,578,208,256 possible passwords If you can attack 100,000,000 passwords per second you will need (6^26)/100,000,000 = 1,705,817,281,795 seconds. 1,705,817,281,795s * 1h/3600s = 473,838,133 hours 473,838,133,832h * 1d/24h = 19,743,255 days 19,743,255,576d * 1y/365d = 54,091 years If we add the condition that passwords can be upper and lower case then there are 6^26 possible passwords and the time to attack all possible combinations becomes: 9.226E24 years. Back to work now :) -- Paul -Original Message- Waleed Sent: Tuesday, December 17, 2002 2:16 PM To: Multiple recipients of list ORACLE-L It's one way encryption. So you can loop on all the permutation for AA to ZZ and apply the encryption code and compare the output to the dictionary content. If it matches, then you got the password. I thought about doing this five years ago, but decided against it. I thought I will be under the hackers, virus developers groups. Regards, Waleed -Original Message- Sent: Tuesday, December 17, 2002 12:04 PM To: Multiple recipients of list ORACLE-L How, Oracle does not publish the password encryption algorithm, and I don't believe anyone has cracked it. Jared Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password nope u can get the encripted password from the oracle dictionáry -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 11:34 To: Multiple recipients of list ORACLE-L Check the post-it note on their monitor? :) -Original Message- Sent: 17 December 2002 10:55 To: Multiple recipients of list ORACLE-L he can't but he can change it to a new one and then put the old back on -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 4:09 To: Multiple recipients of list ORACLE-L how can a dba see the password of a user. The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: password
ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Storing of number datatype in table
I think the number is still being stored as 11, but only being displayed in E notation. When I try it I get: scott select * from trnid; TRN_ID -- 1 1 11 11 Elapsed: 00:00:00.00 scott I entered both as a number 1 and a character string '1', like you did. Have you specified a format for the trn_id column? -- Paul -Original Message- [EMAIL PROTECTED] Sent: Friday, November 22, 2002 6:24 AM To: Multiple recipients of list ORACLE-L Dear List Have a look at the sql !!! SQL create table trnid 2 ( trn_id number(10)); Table created. SQL insert into trnid(trn_id) values('11');/* 10 1's inserted*/ 1 row created. SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/ 1 row created. SQL commit; Commit complete. SQL select trn_id from trnid; TRN_ID - 1.111E+09 1 can anyone tell why the number(10) is stored in exp format Regards, Sathyanarayanan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Check Constraint
You could always do a select to see which rows will violate the check. If you add a check like (X5) then to see what rows would violate this do something like: select * from table where X=5; -- Paul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 4:14 PM When a check constraint is added to a table, is there an option in Oracle that will display or list the rows in the table that violate the constraint ? TIA. Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JJ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: CRONTAB JOB
Check the cron/crontab man pages to see what environment is setup for jobs run from cron. You can also re-direct any output from you script to a file, i.e. /opt/qqad/sql/QQAD_backupscript.sh /some_file 21 This should send STDOUT and STDERR to /some_file. Inside your script you can also show you current environment, env, printenv, set, etc. The output can then be re-directed to a file. We had an issue on AIX where the environment that cron run jobs used was different than the one you got just by logging in. -- Paul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 15, 2002 11:28 AM Hi All, I have a crontab job but this job never started, I have no idea what's wrong, actualy i am not a unix person, here is the job: cron job name is : qqad.cron 04 17 * * 1-5 /opt/qqad/sql/QQAD_backupscript.sh and here is the QQAD_backupscript.sh (in /opt/qqad/sql) sqlplus system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL; cold_back.sql is generated by COLD_BAKUP_FOR_QQADha.SQL @/opt/qqad/sql/cold_back.sql; If I run the job manualy it is going OK but crontab never start. Any Idea?? Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Branching logic in PL/SQL, positive instead of exception
RE: Branching logic in PL/SQL, positive instead of exceptionDoesn't a cursor loop only process the loop body when records are found? If this is true then you will never execute the loop body when the %notfound condition is true, control has already passed to the next statement following the for loop. -- Paul - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, March 15, 2002 7:58 PM As an extension of this conversation, if I have eight conditional queries, eg.: for i_row in main loop build sql declare cursor a select stuff for a_row in a loop if a%found do stuff elsif a%notfound declare cursor b select stuff for b_row in b loop if b%found do stuff elsif b%notfound declare cursor c select stuff for c_row in c loop I'm having trouble with the %notfound and passing control. Do you see what I've done wrong? Thanks, Linda -Original Message- Sent: Wednesday, March 13, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Use SQL%found It's in the manual. :) Jared Hagedorn, Linda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/13/02 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Branching logic in PL/SQL, positive instead of exception Hello, I'm looking for an example of structured PL/SQL code that does not use exception logic for branching, but instead recognizes that data is found. As a bad example, Select col1 from test.table t where exists (select z.zip from zip_table z where t.zip=z.zip ) into v_col1 ; exception when no_data_found begin select col2 from test.table2 t2 where exists (select z.zip from zip_table z where t2.zip=z.zip) into v_col1 ; ; exception when no_data_found begin I've checked the books and cannot see how to test for a positive result instead of a negative (exception) result. Does anyone have a good example of branching logic on record found? Thanks, Linda -- 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: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).