Oracle Database Discussions

Hi,

I am trying to take a schema (A) from one DB (X) and merge it to schema (A) on DB (Y). IF the table exists then I simply would like to append the data that is not currently there. If the object does not exists then bring it on Y. I hope this makes sense.

If I use the TABLE_EXISTS_ACTION=APPEND, can I use this parameter when using the schema option, like as follows?

expdp A/A@X schemas=A directory=TEST_DIR dumpfile=A.dmp logfile=expdpA.log

and then this...

impdp A/A@Y schemas=A directory=TEST_DIR dumpfile=A.dmp logfile=impdpA.log TABLE_EXISTS_ACTION=APPEND

Will this work this way or does the TABLE_EXISTS_ACTION=APPEND only work when I use the tables options?

Message was edited by:
RG