RE: Oracle feature like DTS?
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <gabriel.aragon@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Nov 2004 12:31:00 -0500
Yes, on the high end there's Oracle Transformation Services. On the
lower end you use SQL*Loader or external tables, SQL, PL/SQL,
transparent gateways, heterogeneous services, etc..... It's doable
without the funny widget.=20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Aragon, Gabriel (GE Commercial Finance)
[mailto:gabriel.aragon@xxxxxx]=20
Sent: Wednesday, November 03, 2004 12:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle feature like DTS?
Hi guys,=3D20
this is a question from one of my programmers, you know in SQL server =
=3D
there is this feature called DTS (Data Transformation Services) I have a
=3D
basic knowledge of this tool and use it only to export/import data =3D
through Oracle/SQL and data movement in SQL, but I know it is capable to
=3D
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 =
=3D
proc that use an external table to load and process data, and finally =
=3D
crontab the entire operation, but (unfortunately) we are running under =
=3D
win2k.=3D20
Question: Is there anything similiar to DTS in Oracle to "pack" all the
=3D
steps?=3D20
Comments are welcome.=3D20
TIA.
Gabriel=3D20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
