Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database/schema merge - best practices?

935081May 4 2012 — edited May 4 2012

Hello,
I am an Oracle newbie and have been given an assignment at work to take the objects in schema A on server X and import them into schema B on server Y. The goal is to eventually eliminate schema B and server Y. Schema B has real-time data being imported from yet another database (SQL Server). What are some general best practices for achieving this type of activity? I have never done anything like this before. Thank you very much.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2012

Added on May 4 2012

#database-key-features, #export-import-sql-loader-external-tables, #import

2 comments

454 views