> "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: sfaroult_at_oriole.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:23:59 CST
