Pauline,

You can use external Tables to read the data from the Falt files after
they are FTpd to the required directory. Design a procedure that reads
the data from the external table and loads the data into required
tables similat 'insert into select from' and your validations. You can
schedule the execution of SP based on what time you have your feed
coming into.


Regards,

Viswa





-----Original Message-----
From: pauline
[mailto:oracledba-ezmlmshield-x98117779.[Email address protected]
Sent: Tuesday, January 08, 2008 1:58 PM
To: LazyDBA Discussion
Subject: Re: export schema

Hi All,

Please assist if you can, or point me to the right direction. Any
documents will be appreciated.
We are currently running Oracle 9i on a Windows server 2003. I need to
upload data from an excel spreadsheet (a flat file that is being ftp'd
onto the server from a remote SQL server database) onto the oracle db
table. A process has been put in place and is working fine. I do get
all the data into my database (oracle).
Now the challenge is automating the process such that once the FTP is
complete, our process is triggered and the upload done.

Your assistance will be appreciated as I have run out of ideas.

Regards,
Pauline (A junior dba)


If you are not the addressee, please inform us immediately that you have
received this e-mail by mistake, and delete it. We thank you for your
support.

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page