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
3. exchange the partition with the newly created table
4. 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

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_000_01C28C1F.0F59EE57--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: Madhusudana.Reddy_at_bestbuy.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).