2 Replies Latest reply: May 4, 2012 1:47 PM by L-MachineGun RSS

    Database/schema merge - best practices?

    935081
      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.