This discussion is archived
2 Replies Latest reply: May 4, 2012 11:47 AM by L-MachineGun RSS

Database/schema merge - best practices?

935081 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points