Database Utilities (MOSC)

MOSC Banner

DataPump export schema level alternative.....

edited Apr 10, 2012 4:14AM in Database Utilities (MOSC) 1 commentAnswered
Hi All,

Thank you for your assistance....

I am trying to migrate a database from one server (11.1.0.7) to another (11.2.0.3)

I have successfully exported 10 out of 11 schemas using datapump...

I could not export the last large one because of the idle wait 'wait for unread message on broadcast channel' errors which is unresolvable....

The others are smaller, and I have decided to export the large tablespace in chunks, i.e tables.  I am concerned about the other objects that exist in this schema,

that I will lose, eg procedures, views, etc, etc...

Is there a way I can import everything else too without doing a full schema export which will not work...

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