[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: RE: Unix or SQL Loader: How to automated a Copy-move process
From: Elango Velayutham <TS3098 () emirates ! com>
Date: 2004-05-05 3:24:08
Message-ID: F001.005E3E0A.20040504201426 () fatcity ! com
[Download RAW message or body]
Hi,
How about using an oracle procedure run thro' dbms_job. You can always treat
these files as external tables load them and then call a pl/sql wrapper
procedure (for a java or C program that resides and runs in the database
itself) that copies to the desired folder.
Check asktom.oracle.com for a java based solution that lets you run OS
commands inside the database itself. This way you will be having total
control of your programs inside the database itself.
HTH
Elango
-----Original Message-----
Sent: 04 May 2004 20:09
To: Multiple recipients of list ODTUG-SQLPLUS-L
We have tackled this problem with the use of our EDI group. They pickup the
files, run the SQL Load and move the files to a processed directory and
report any errors encountered. It all works very well.
Robert Lindberg
Project Leader
Wilsonart International
254-207-2831
>>> alfpathros@web.de 05/04/04 10:49AM >>>
Hello Gurus! Please help! I would like to get some help with the following:
I'm working right now on a Data Warehouse project and I need to automate a
manual procedure I am using to process the data files coming into the
database, any information/ideas and or which script language to go with,
would be greatly appreciated. Procedure:I have 2 stages directory
architecture."Receiving_NewFiles" directory and "Files_Processed" directory:
Check the receiving directory for new files coming from an external system
(ASCII format or non relational DBs format) and import/transport them into
the database once this is done, rename the processed files and transfer them
into an archiving directory called Files_Processed. I would also like to
have this procedure run automatically every 5 minutes. I would like to some
how generate an error_log/alert_log file to monitor whether the process run
successfully or not, additionally, I would also like it to record the name
of any file that can't b! e processed or transferred. Environment:OS: AIX
5.2Oracle 9i R2 Thanks a lot in advance for your help, day Cheers, Alf
Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Sober.A-F!
Kostenfrei fuer FreeMail Nutzer. http://f.web.de/?mc=021158 -- ODTUG Now!
2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland Resort,
Scottsdale, Arizona. Visit http://www.odtug.com for details.-- Author: Alf
Baez INET: alfpathros@web.de Fat City Hosting, San Diego, California --
http://www.fatcity.com
--------------------------------------------------------------------- To
REMOVE yourself from this mailing list, send an E-Mail message to:
ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
--
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin
Kierland Resort, Scottsdale, Arizona. Visit http://www.odtug.com for
details.--
Author: Robert Lindberg
INET: lindber@wilsonart.com
Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2656.60">
<TITLE>RE: Unix or SQL Loader: How to automated a Copy-move process</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi,</FONT>
</P>
<P><FONT SIZE=2>How about using an oracle procedure run thro' dbms_job. You can \
always treat these files as external tables load them and then call a pl/sql wrapper \
procedure (for a java or C program that resides and runs in the database itself) that \
copies to the desired folder.</FONT></P>
<P><FONT SIZE=2>Check asktom.oracle.com for a java based solution that lets you run \
OS commands inside the database itself. This way you will be having total control of \
your programs inside the database itself.</FONT></P>
<P><FONT SIZE=2>HTH</FONT>
<BR><FONT SIZE=2>Elango </FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Robert Lindberg [<A \
HREF="mailto:lindber@wilsonart.com">mailto:lindber@wilsonart.com</A>] </FONT> \
<BR><FONT SIZE=2>Sent: 04 May 2004 20:09</FONT> <BR><FONT SIZE=2>To: Multiple \
recipients of list ODTUG-SQLPLUS-L</FONT> <BR><FONT SIZE=2>Subject: Re: Unix or SQL \
Loader: How to automated a Copy-move process</FONT> </P>
<BR>
<P><FONT SIZE=2>We have tackled this problem with the use of our EDI group. They \
pickup the files, run the SQL Load and move the files to a processed directory and \
report any errors encountered. It all works very well.</FONT></P>
<P><FONT SIZE=2>Robert Lindberg</FONT>
<BR><FONT SIZE=2>Project Leader</FONT>
<BR><FONT SIZE=2>Wilsonart International</FONT>
<BR><FONT SIZE=2>254-207-2831</FONT>
</P>
<P><FONT SIZE=2>>>> alfpathros@web.de 05/04/04 10:49AM >>></FONT>
<BR><FONT SIZE=2>Hello Gurus! Please help! I would like to get some help with the \
following: I'm working right now on a Data Warehouse project and I need to automate a \
manual procedure I am using to process the data files coming into the database, any \
information/ideas and or which script language to go with, would be greatly \
appreciated. Procedure:I have 2 stages directory \
architecture."Receiving_NewFiles" directory and "Files_Processed" \
directory: Check the receiving directory for new files coming from an external system \
(ASCII format or non relational DBs format) and import/transport them into the \
database once this is done, rename the processed files and transfer them into an \
archiving directory called Files_Processed. I would also like to have this procedure \
run automatically every 5 minutes. I would like to some how generate an \
error_log/alert_log file to monitor whether the process run successfully or not, \
additionally, I would also like it to record the name of any file that can't b! \
e processed or transferred. Environment:OS: AIX 5.2Oracle 9i R2 Thanks a lot in \
advance for your help, day Cheers, Alf </FONT></P>
<P><FONT SIZE=2>Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm \
Sober.A-F! </FONT> <BR><FONT SIZE=2>Kostenfrei fuer FreeMail Nutzer. <A \
HREF="http://f.web.de/?mc=021158" \
TARGET="_blank">http://f.web.de/?mc=021158</A> -- ODTUG Now! 2004, Let Us Show \
you How! June 20-24, 2004 at the Westin Kierland Resort, Scottsdale, Arizona. Visit \
<A HREF="http://www.odtug.com" TARGET="_blank">http://www.odtug.com</A> for \
details.-- Author: Alf Baez INET: alfpathros@web.de Fat City Hosting, San Diego, \
California -- <A HREF="http://www.fatcity.com" \
TARGET="_blank">http://www.fatcity.com</A> \
--------------------------------------------------------------------- To REMOVE \
yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com \
(note EXACT spelling of 'ListGuru') and in the message BODY, include a line \
containing: UNSUB ODTUG-SQLPLUS-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). \
</FONT></P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin \
Kierland Resort, Scottsdale, Arizona. Visit <A HREF="http://www.odtug.com" \
TARGET="_blank">http://www.odtug.com</A> for details.-- </FONT></P>
<P><FONT SIZE=2>Author: Robert Lindberg</FONT>
<BR><FONT SIZE=2> INET: lindber@wilsonart.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Hosting, San Diego, California -- <A \
HREF="http://www.fatcity.com" TARGET="_blank">http://www.fatcity.com</A></FONT> \
<BR><FONT SIZE=2>---------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail \
message</FONT> <BR><FONT SIZE=2>to: ListGuru@fatcity.com (note EXACT spelling of \
'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).</FONT></P>
</BODY>
</HTML>
--
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland
Resort, Scottsdale, Arizona. Visit http://www.odtug.com for details.--
Author: Elango Velayutham
INET: TS3098@emirates.com
Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic