Database Administration (MOSC)

MOSC Banner

Datapump import

edited Oct 20, 2011 12:22PM in Database Administration (MOSC) 7 commentsAnswered
Dear all,

Having created a nice new Oracle 11g database, I wanted to import one schema from a 10g db into it using the Datapump REMAP_SChema function. All worked well, until I realised that I hadn't limited the IMPORT to just that schema, was using a full export, and was importing as system. Most of the other schemas within the export pump failed (because I hadn't set up tablespaces for them) which is good - I've just got the schema I wanted (and a couple of small ones that won't matter)  but I've realised that SYSTEMs and probably SYS' objects were also imported. Most

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