Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ETL between 2 Oracle 9i databases?
I don't know how big the tables you're dealing with are so i'll give
you two options.
1 - bring data over from the 1st db into your 2nd with a database link
and write a proc to do the transform.
2 - export the relevant data if the tables are on the larger side and
re-import them into the the second db and run your transform
Cheers,
Shakir
Received on Sat Feb 04 2006 - 16:20:06 CST