RE: Urgent : Shell Script is needed !!!!!

[Kevin Lange]

Title: Blank

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 [EMAIL PROTECTED] .....  I will need to take the time to find the code outside of work.   Kevin  -----Original Message----- From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 14, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Subject: Urgent : Shell Script is needed !!!!! 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: 1. get the oldest partition name from a partitioned table 2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure 2. exchange the partition with the newly created table 3. 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