<!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@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
[mailto:kgel@ppoone.com]<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> 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> </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, 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> </DIV>
<DIV><FONT face=Arial><SPAN class=190361922-14112002>If you would be
interested, contact me offline at <A
href="mailto:vino@vinosplace.com">vino@vinosplace.com</A> ..... 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> </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> </SPAN>-----Original
Message-----<BR><B>From:</B> Reddy, Madhusudana
[mailto:Madhusudana.Reddy@bestbuy.com]<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> </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> </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> </P>
<P></SPAN></FONT><STRONG><FONT face=Verdana color=#008080
size=1>Regards,</FONT></STRONG></P></DIV>
<DIV><FONT color=#800040><STRONG>Madhu
Reddy</STRONG></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
- Urgent : Shell Script is needed !!!!! Reddy, Madhusudana
- Re: Urgent : Shell Script is needed !!!!! Stephane Faroult
- RE: Urgent : Shell Script is needed !!!!! Kevin Lange
- Reddy, Madhusudana
