If I were you I would talk to that management.
We had a Mainframe DB2 database that needed to have shadow tables created on
Oracle. What we ended up doing was to get Oracles Gateway for RDB which
allowed us to create queries on Oracle that accessed data on the mainframe
DB2.
We even went one st
I've done db to db transfers using either
1) Perl/DBI - db to db - select from first, insert into second
2) Perl/DBI - select from first, create file for SQL*Loader, load
into Oracle using SQL*Loader
I've usually found #2 to be quicker...usually...
-Joe
--- "Schauss, Peter" <[EMAIL PROTECTED]
