RE: OT : Unix Mail
Hi, I've found the answer. Thanks. -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Tuesday, May 22, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Subject:OT : Unix Mail Hi Unix Gurus, Does anyone know how to send a file db_backup.log to receipient [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cc [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with Subject Backup Log file in Unix ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: historical data
Hi David, If there is a remote possibility of loading this data back into Oracle XX database (or any other, for that matter), then what you are doing makes perfect sense. I used to unload data into flat files when I worked on the mainframe systems a few years ago. And a few times we did have to load it back into newer versions of the database. You are on the right track. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 5:17 PM To: Multiple recipients of list ORACLE-L Subject: historical data We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I was wondering is does anyone have an alternative that is better? I thought about using export but thought it wouldn't be fun trying to import an export file into the latest version of Oracle 10 years down the road. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: example of using clause RETURNING
How about: DECLARE TYPE NumList IS TABLE OF emp.empno%TYPE; enums NumList; BEGIN DELETE FROM emp WHERE deptno = 20 RETURNING empno BULK COLLECT INTO enums; -- if there were five employees in department 20, -- then enums contains five employee numbers END; Jared On Monday 21 May 2001 15:35, Hillman, Alex wrote: Could somebody please provide an example of returning clause for update, delete or insert SQL statement when there is an update, delete or insert of multiple rows. I know how to do it if there is one row. Alex Hillman -- 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: historical data
My first recommendation would be to do this with Perl and DBI. Fairly simple that way. If not, try using SQL generating SQL to spool the data out. Check out dump.sql at www.cybcon.com/~jkstill/util, and modify for your needs. UTL_FILE will probably not work for this due to buffer limitations. Jared On Monday 21 May 2001 15:17, David Turner wrote: We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I was wondering is does anyone have an alternative that is better? I thought about using export but thought it wouldn't be fun trying to import an export file into the latest version of Oracle 10 years down the road. Thanks, Dave -- 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: historical data
What did you use as a delimiter, and are their any limits on tables I can write to a file? Thanks, Dave On Mon, May 21, 2001 at 09:47:20PM -0500, Deshpande, Kirti wrote: Hi David, If there is a remote possibility of loading this data back into Oracle XX database (or any other, for that matter), then what you are doing makes perfect sense. I used to unload data into flat files when I worked on the mainframe systems a few years ago. And a few times we did have to load it back into newer versions of the database. You are on the right track. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 5:17 PM To: Multiple recipients of list ORACLE-L Subject:historical data We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I was wondering is does anyone have an alternative that is better? I thought about using export but thought it wouldn't be fun trying to import an export file into the latest version of Oracle 10 years down the road. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: historical data
Thanks, Dave On Mon, May 21, 2001 at 08:05:23PM -0700, Jared Still wrote: My first recommendation would be to do this with Perl and DBI. Fairly simple that way. If not, try using SQL generating SQL to spool the data out. Check out dump.sql at www.cybcon.com/~jkstill/util, and modify for your needs. UTL_FILE will probably not work for this due to buffer limitations. Jared On Monday 21 May 2001 15:17, David Turner wrote: We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I was wondering is does anyone have an alternative that is better? I thought about using export but thought it wouldn't be fun trying to import an export file into the latest version of Oracle 10 years down the road. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Set transaction use rollback??
Hello Gurus I just would like to know when this statement SET TRANSACTON USE ROLLBACK SEGMENT 'XXX' should be used exactly. In the sense should I always write it after a BEGIN(for all my programs) or should I write it in processes which involves HUGE volume of records. Please clarify Regards Vishak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vishak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nothing to do with Oracle : But is is very important : Your reaction please
OK, this is *way* off topic for this list. At times the folks here stray from Oracle, but if you wish to start political discussions, do it somewhere else please. Jared ( the list owner ) On Monday 21 May 2001 13:40, palestine Qods wrote: Hello, Please take a look at this and give your reaction : http://www.humanityonhold.com/intifada.html YOUR REACTION PLEASE THANKS A LOT Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Nothing to do with Oracle : But is is very important : Your reaction please
After looking at the address, I realized that this subscriber is simply a spam account, and removed it accordingly. Jared On Monday 21 May 2001 13:40, palestine Qods wrote: Hello, Please take a look at this and give your reaction : http://www.humanityonhold.com/intifada.html YOUR REACTION PLEASE THANKS A LOT Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: historical data
David, It was mainframe and COBOL shop, we did not use delimiters in the data files. All the files were using fixed format for data fields. There was one file per table (datasets as they are called in the Burroughs (Unisys) DMSII database). I think one file per table would be much easier to deal with (SQL*Loader, for example). Logically combining data while unloading is another method to consider to save number of files/disk space etc. However, re-loading from such data will be a rather involved process. Of course, YMMV.. You may also know that Jared has a dump.sql script to unload table data into a comma delimited ASCII file. I have used that script a few times. Works great. It also builds the SQL*Loader control file to load the data back. You can find it at http://www.cybcon.com/~jkstill/util/util_master.html. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:59 PM To: Deshpande, Kirti Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: historical data What did you use as a delimiter, and are their any limits on tables I can write to a file? Thanks, Dave On Mon, May 21, 2001 at 09:47:20PM -0500, Deshpande, Kirti wrote: Hi David, If there is a remote possibility of loading this data back into Oracle XX database (or any other, for that matter), then what you are doing makes perfect sense. I used to unload data into flat files when I worked on the mainframe systems a few years ago. And a few times we did have to load it back into newer versions of the database. You are on the right track. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 5:17 PM To: Multiple recipients of list ORACLE-L Subject: historical data We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I was wondering is does anyone have an alternative that is better? I thought about using export but thought it wouldn't be fun trying to import an export file into the latest version of Oracle 10 years down the road. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).