Database Utilities (MOSC)

MOSC Banner

IMPDP: creating only index, trigger; constrains from Full-EXPDP

edited Jun 16, 2010 12:56AM in Database Utilities (MOSC) 2 commentsAnswered
With the old "imp" i could easy import only Packages, Triggers, Indexes .. after I imported all tables with data. How can I do this with impdp?
I try it with "content=metadata_only," but when I say "table_exists_action=skip" and the tables all exists this option ignore also all triggers, indexes, constraints on this tables.
To do this with the "sqlfile" of the impdp is also not easy because I have  full expdp files with more than 40.000 objects.

Many thanks for any help,
Brigitte

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