|
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
|
<<Blank Bkgrd.gif>>
