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.
In 12c now we have a feature called FULL TRANSPORTABLE TABLESPACE feature. Practice it!
Path to Documentation:
Administrator’s Guide -> Transporting Tablespaces Between Databases
Click here to go back to the Main OCM 12c Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
