<!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 [mailto:kgel_at_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_at_vinosplace.com">vino_at_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_at_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>
--
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).
Received on Fri Nov 15 2002 - 15:23:28 CST
