RE: Oracle feature like DTS?

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_at_ge.com]=20
Sent: Wednesday, November 03, 2004 12:18 PM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l