Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent : Shell Script is needed !!!!!

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

From: Reddy, Madhusudana <>
Date: Fri, 15 Nov 2002 13:23:28 -0800
Message-ID: <>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Blank</TITLE> <META http-equiv=Content-Type
content="text/html; charset=iso-8859-1"> <STYLE>BODY { MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 25px; COLOR: #000000; FONT-FAMILY: Arial, Helvetica } P.msoNormal { MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; FONT-FAMILY: Helvetica, "Times New Roman" } LI.msoNormal { MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; FONT-FAMILY: Helvetica, "Times New Roman" } </STYLE> <META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD> <BODY background=cid:038384020_at_14112002-0075> <DIV><SPAN class=679451820-15082002><FONT face="Comic Sans MS" color=#0000ff>Thank you for the mail , i have prepared a script by reading some examples which were written in the past </FONT></SPAN></DIV> <DIV><SPAN class=679451820-15082002><FONT face="Comic Sans MS" color=#0000ff>thanks again</FONT></SPAN></DIV> <DIV><SPAN class=679451820-15082002><FONT face="Comic Sans MS" color=#0000ff>Madhu</FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma>-----Original Message-----<BR><B>From:</B> Kevin Lange []<BR><B>Sent:</B> Thursday, November 14, 2002 4:24 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Urgent : Shell Script is needed !!!!!<BR><BR></FONT></DIV> <DIV><SPAN
class=190361922-14112002><STRONG>Madhu</STRONG></SPAN></DIV> <DIV><SPAN class=190361922-14112002>&nbsp; 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.</SPAN></DIV>
<DIV><SPAN class=190361922-14112002></SPAN><FONT face=Tahoma><FONT
face=Arial></FONT><FONT face=Arial></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=Tahoma><SPAN class=190361922-14112002><FONT face=Arial>Ifs complicated, but if you think you might be interested in looking thru it to make your own,&nbsp;I can find the SQL code and UNIX code that went with it.</FONT></SPAN></FONT></DIV> <DIV><FONT face=Arial><SPAN class=190361922-14112002></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial><SPAN class=190361922-14112002>If you would be interested, contact me offline at <A
href=""></A> .....&nbsp; I will need to take the time to find the code outside of work.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma><SPAN class=190361922-14112002><FONT
face=Arial></FONT></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Tahoma><SPAN class=190361922-14112002><FONT face=Arial>Kevin</FONT></SPAN></DIV>
<DIV><FONT face=Arial></FONT><BR><SPAN

class=190361922-14112002>&nbsp;</SPAN>-----Original Message-----<BR><B>From:</B> Reddy, Madhusudana []<BR><B>Sent:</B> Thursday, November 14, 2002 2:50 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Urgent : Shell Script is needed !!!!!<BR><BR></DIV></FONT> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face="Trebuchet MS" color=#000080><SPAN
class=038384020-14112002>Hello All,</SPAN></FONT></DIV> <DIV><FONT face="Trebuchet MS" color=#000080><SPAN
class=038384020-14112002></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face="Trebuchet MS"><SPAN class=038384020-14112002> <P><FONT face="Times New Roman"><FONT color=#000080>I have to do automation of manual process of the following things, being not good at the <STRONG>Shell scripting</STRONG> , I need your help or at least a sample script<SPAN class=038384020-14112002> would be great</SPAN></FONT></FONT></P> <P><FONT face="Times New Roman" color=#000080><SPAN class=038384020-14112002><STRONG>Manual process:</STRONG></SPAN></FONT></P> <P><FONT face="Times New Roman" color=#000080>1. get the oldest partition name from a partitioned table</FONT></P> <P><FONT face="Times New Roman" color=#000080>2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure</FONT></P> <P><FONT face="Times New Roman" color=#000080>2. exchange the partition with the newly created table
</FONT></P> <P><FONT face="Times New Roman" color=#000080>3. then export the
new table to a Unix directory.</FONT></P> <P><FONT face="Times New Roman" color=#000080></FONT>&nbsp;</P> <P><SPAN class=038384020-14112002><FONT face="Times New Roman" color=#000080>Later I have to drop the oldest partition .( For this we have a procedure to take care of )</FONT></SPAN></P> <P><FONT face="Times New Roman"

color=#000080></FONT>&nbsp;</P> <P></SPAN></FONT><STRONG><FONT face=Verdana
color=#008080 size=1>Regards,</FONT></STRONG></P></DIV> <DIV><FONT

Please see the official ORACLE-L FAQ:
Author: Reddy, Madhusudana

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Fri Nov 15 2002 - 15:23:28 CST

Original text of this message