Database Administration (MOSC)

MOSC Banner

after autoupgrade, DATA_PUMP_DIR exist but cannot be dropped

edited Oct 31, 2025 3:43PM in Database Administration (MOSC) 2 commentsAnswered

Hi everyone,

After autoupgrade to 19c PDB from 11g, dba_directories show data_pump_dir exists, but cannot be dropped, I tried to use upper and lowercase, still unable to dropped. Please advise.

SQL> show con_name

PDBQA004

SQL> select * from dba_directories where directory_name = 'DATA_PUMP_DIR';

OWNER DIRECTORY_NAME DIRECTORY_PATH ORIGIN_CON_ID

SYS DATA_PUMP_DIR /u01/app/oracle/product/19240E/rdbms/log/42186CB2D07F601FE06 1
4000000000010

SQL> drop directory DATA_PUMP_DIR;
drop directory DATA_PUMP_DIR
*
ERROR at line 1:
ORA-04043: object DATA_PUMP_DIR does not exist

SQL> DROP DIRECTORY "data_pump_dir";

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