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

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

1.
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 :
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: 64139
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.

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


Current Time: Thu Dec 08 16:16:07 CST 2016

Total time taken to generate the page: 0.23666 seconds