after autoupgrade, DATA_PUMP_DIR exist but cannot be dropped
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";