Database Administration (MOSC)

MOSC Banner

19c - how to check for conflicting DDL before running expdp

edited Feb 25, 2020 11:16AM in Database Administration (MOSC) 3 commentsAnswered ✓

How does one check for conflicting DDL before running the expdp script?

expdp anadmin/psd@db1 schemas=CHIU directory=MYEXPORTS dumpfile=CHIU.dp logfile=CHIU.log ........Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSORA-39374: Statistics failed to export. Failing error is ORA-14411: The DDL cannot be run concurrently with other DDLsProcessing object type SCHEMA_EXPORT/USER.......

Single Tenant Database, 19c, release 19.4.0.0, Linux 7

Thanks

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