Database Utilities (MOSC)

MOSC Banner

What happens when impdp with dblink will REPLACE the same table?

edited Mar 4, 2015 1:45PM in Database Utilities (MOSC) 12 commentsAnswered

Oracle 11.2.0.4 on AIX 6.1 or AIX 7.1

I just write a Procedure with which application peaple can copy tablespaces von between different instances in they own schema. For this i use the network_link option of impdp. The procedure should also avoid some errors which currently can happens with the impdp utility : perhaps using TABLE_ACTION=TRUNCATE und use the same table and the same instance ins the dblink. I tested it with the impdp utility and the impdp wrote error message: it works as design: first the table was truncated and after this the data the truncated table was copied with the result, that - from now on

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