Hi,
I want to drop a schema and this schema contains lot of java class and source.
drop user schemaname cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04043: object /ca110a05_javaclassname1 does not exist
I wanted to drop java objects one by one. (The schema contains only "java source" and "java class" objects.)
For example I have a java class and source in schema with same name, like: schema1."java/classname"
drop java source schema1."javafolder/classname"
*
ERROR at line 1:
ORA-04043: object /ca110a05_SingularVDeco does not exist
drop java class schema1."javafolder/classname"
*
ERROR at line 1:
ORA-29537: class or resource cannot be created or dropped directly
Thanks for any help!