OCM 11g Preparation - Manage Transport of tablespaces across platforms

Transporting whole tablespaces is a very good and practical way to move data from one Database to another. Oracle will generate a small dump with the object's metadata and all you need to do is copy the datafiles and dumps to the new system.

In this topic, practice:

  • Check if Transport is possible with DBMS_TTS.TRANSPORT_SET_CHECK
  • Transportable expdp
  • Convert between different Endians
  • Transportable impdp.

Try also using Enterprise Manager Grid Control. It can be faster.

Path to Documentation:

Administrator's Guide -> Transporting Tablespaces Between Databases


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.