drop directory = ora-04043
hi,
droping a directory gives an ora-04043
17:07:10 SQL> show user;
USER is "SYS"
17:07:17 SQL> select * from dba_directories;
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS mondir
d:\mondir
SYS ORACLE_OCM_CONFIG_DIR
d:\oracle\product\1020~1.1\ccr\state
SYS DATA_PUMP_DIR
D:\oracle\product\admin\gnxdev\dpdump
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS TMP_DIR
f:\temp\
--
17:07:21 SQL> drop directory mondir;
drop directory mondir
*
ERROR at line 1:
ORA-04043: object MONDIR does not exist
I Also tried with uppercase and quoted string without success.
Sys user has the following sys privs:
GRANT CREATE ANY DIRECTORY TO "SYS" WITH ADMIN OPTION;
GRANT DROP ANY DIRECTORY TO "SYS" WITH ADMIN OPTION;
Thanks for your help.