Oracle database export datapump fails with ORA-39374 and ORA-01732

One of the databases I have recently upgraded to Oracle 12cR2 , the export datapump was failing and never continues to finish. This was wired….the following errors were thrown in the export log file:

ORA-39374: Statistics failed to export. Failing error is
ORA-01732: data manipulation operation not legal on this view

To troubleshoot this problem:

Try taking full database export datapump with the clause “EXCLUDE=STATISTICS

if this doesn’t fix your problem then check the parameter size of streams_pool_size it should be at least 300 MB. changing this parameter value actually fixed my problem !

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s