Home » RDBMS Server » Server Administration » its urgent please
its urgent please [message #306383] Fri, 14 March 2008 00:11 Go to next message
Messages: 39
Registered: May 2005
Location: Islamabad

someone accediently executed CATPROC script in his DBA privileged schema (PROG3). since then while compiling forms following error stack is arising:

ORA-04029 error ORA-942 occured when quering ORA_KGLR7_DEPENDENCIES
ORA-00604 error ocured at recursive SQL level 1
ORA-00942 table or view does not exist

2. when i try to connect SQLPLUSW, it connects to schema but with following error :
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

3. while dropping a user :
drop user prog3 cascade
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, stored procedure "PROG3.DICTIONARY_OBJ_TYPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Re: its urgent please [message #306390 is a reply to message #306383] Fri, 14 March 2008 01:03 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read OraFAQ Forum Guide.
Review your title.
Then I start to read your post.

Previous Topic: New databsae in exsisting db server
Next Topic: opatch requirement
Goto Forum:

Current Time: Sat Jul 22 06:13:21 CDT 2017

Total time taken to generate the page: 0.14236 seconds