Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Location
    Serbia
    Posts
    17

    Unanswered: New schema location

    Hi to all folks!
    My name is Aleksandar from Serbia and im new here on your forum, so hi again

    I have to do schema migration into new database, but before doing that i have feeling that i need to done some steps to be sure that this work will be done ok. So i have checked disk capacity availability on each server and i have few possible db's but what also need to be done and how?
    Just to say im junior DBA and i really need your help with this...

    Thanks in advance!

    Friendly regards!

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Pump the data

    The best way would be to use the "data pump" (expdb/impdp) utilities to export the schema (and data if you want) end then import into new database.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •