Oracle feature like DTS?
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Nov 2004 12:17:47 -0500
Hi guys,=20
this is a question from one of my programmers, you know in SQL server =
there is this feature called DTS (Data Transformation Services) I have a =
basic knowledge of this tool and use it only to export/import data =
through Oracle/SQL and data movement in SQL, but I know it is capable to =
do other things.
The scenary is like this:
1. Pull a file from FTP
2. Load it into a table
3. Load another table directly from a database
4. Process data and do some inserts into local DB tables
My first thought was to use unix scripts for the FTP stuff and maybe a =
proc that use an external table to load and process data, and finally =
crontab the entire operation, but (unfortunately) we are running under =
win2k.=20
Question: Is there anything similiar to DTS in Oracle to "pack" all the =
steps?=20
Comments are welcome.=20
TIA.
Gabriel=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
