Oracle-L: RE: Urgent : Shell Script is needed !!!!!

From: Kevin Lange <kgel_at_ppoone.com>
Date: Thu, 14 Nov 2002 14:24:00 -0800
Message-ID: <F001.00503D92.20021114142400@fatcity.com>

Madhu
Three years ago we wrote a system that would except files from an outside data system, take those files and , in a rotating 18 month cycle, load the data into a partitioned view .... dropping the oldest set of data and adding the next set in its place.

Ifs complicated, but if you think you might be interested in looking thru it to make your own, I can find the SQL code and UNIX code that went with it.

If you would be interested, contact me offline at vino_at_vinosplace.com <mailto:vino_at_vinosplace.com> ..... I will need to take the time to find the code outside of work.

Kevin

-----Original Message-----
Sent: Thursday, November 14, 2002 2:50 PM To: Multiple recipients of list ORACLE-L

Hello All,

I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great

Manual process:

get the oldest partition name from a partitioned table
create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure
exchange the partition with the newly created table
then export the new table to a Unix directory.

Later I have to drop the oldest partition .( For this we have a procedure to take care of )

Regards,

Madhu Reddy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 14 2002 - 16:24:00 CST