Database Utilities (MOSC)

MOSC Banner

Export/Import question

edited Jun 1, 2012 4:24AM in Database Utilities (MOSC) 3 commentsAnswered
 Hi Gurus,
Oracle Metalink Note 277650.1 says the following:

In Oracle10g you can use the transportable tablespace feature to migrate a database to a different platform by creating a new database on the destination platform and performing a transport of all the user tablespaces. Note that you cannot transport the SYSTEM tablespace. Therefore, objects such as sequences, PL/SQL packages, and other objects that depend on the SYSTEM tablespace are not transported. You must either create these objects manually on the destination database, or use Data Pump to transport the objects that are not moved by transportable tablespace"

How can I find out and create 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center