Database Utilities (MOSC)

MOSC Banner

impdp doesn't truncate a table even with TABLE_EXISTS_OPTION=TRUNCATE

edited Dec 24, 2015 10:04AM in Database Utilities (MOSC) 4 commentsAnswered

A schema import with impdp 11.2.0.3.0 and parameters CONTENT=DATA_ONLY, TABLE_EXISTS_ACTION=TRUNCATE didn't truncate one table among many others which was processed right (truncated and rows inserted from dump).

In the imp logfile was no error message, but for the table there was "0 rows imported" reported.

That was right because the source table in the export dumpfile was actual empty!

I suppose that is not a bug, but expected behavior?!

That can lead to Problems e.g. with sequences however!

In the Oracle Database Utilities documentation I couldn't find any information to that.

Does anybody know a note about the fact that impdp with TABLE_EXISTS_ACTION=TRUNCATE doesn't truncate the table if the source is empty?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center