Skip navigation

Transporting Data from 11g Database to 12c Database

score 90
You have not voted. Active


You can transport data at any of the following levels:   

- Database    

You can use the full transportable export/import feature to move an entire database to a different database instance.      


- Tablespaces    

You can use the transportable tablespaces feature to move a set of tablespaces between databases.      


- Tables, partitions, and subpartitions    

You can use the transportable tables feature to move a set of tables, partitions, and subpartitions between databases.


Transporting data is much faster than performing either an export/import or unload/load of the same data. It is faster because, for user-defined tablespaces, the data files containing all of the actual data are copied to the target location, and you use Data Pump to transfer only the metadata of the database objects to the new database.



Transporting Tablespaces from 11g Database to 12c Database

Transporting data is much faster than performing either an export/import or

unload/load of the same data. It is faster because, for user-defined tablespaces,

the data files containing all of the actual data are copied to the target location,

and you use Data Pump to transfer only the metadata of the database objects to the new database.

 

This whitepaper covers the Transporting Data: Scenarios of “Transportable Tablespaces”

Transporting Tablespaces from 11g Database to 12c Database

Transporting FULL Database from 11g Database to 12c Database

You can use full transportable export/import to upgrade a database from an

Oracle Database 11g Release 2 (11.2.0.3) or later to Oracle Database 12c.

To do so, install Oracle Database 12c and create an empty database.

Next, use full transportable export/import to transport the Oracle Database 11g

Release 2 (11.2.0.3) database into the Oracle Database 12c database.

 

This whitepaper covers the Transporting Data: Scenarios of “full transportable export/import feature”

Transporting FULL Database from 11g Database to 12c Database

Comments

Vote history