Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop directory = ora-04043

user600516Nov 20 2007 — edited Nov 26 2007
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2007
Added on Nov 20 2007
2 comments
592 views