Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ETL between 2 Oracle 9i databases?

Re: ETL between 2 Oracle 9i databases?

From: <shakirsadikali_at_gmail.com>
Date: 4 Feb 2006 14:20:06 -0800
Message-ID: <1139091605.979289.132240@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US