oracle data migration - ghdrako/doc_snipets GitHub Wiki

Method

• Using Copy in SqlDeveloper
• Using old imp/exp
• Using impdp/exdp
• Using transportable tablespace
• Using transportable tablespace with RMAN conversion
• Using Full transportable export/import

Full transportable export/import

Full transportable export/import can take advantage of Data Pump options such as the ability to move metadata over a database link, and is able to accomplish a full database migration with a single import command.
At the same time, full transportable export/import uses the transportable tablespaces mechanism to move user and application data.