> "Reddy, Madhusudana" wrote: > > 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 >
Hint : do most of it as a SQL script rather than a shell script. -- 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 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).
