-
PL/SQL re-installation
Something happen few days ago which i dont want reveal and some of the views and packages become invalid, so i tried to reinstall PL/SQL.
Before reinstalling what is my mistake is to delete all the packages
and types including the Standard package.
Now iam trying to reinstall PL/SQL, but i got following errors.
Please help me out.
The following are the series of steps i followed for reinstallation
SQL> @\\Ed10\c_oracle\ora92\rdbms\admin\catalog.sql
create or replace
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
ORA-06553: PLS-213: package STANDARD not accessible
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
"after the above error i added the following parameter in init.ora file
_system_trig_enabled=false
and rerun the script"
SQL> startup pfile="C:\Documents and Settings\Administrator\Desktop\init.ora"
ORACLE instance started.
Total System Global Area 655433488 bytes
Fixed Size 454416 bytes
Variable Size 603979776 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> @\\Ed10\c_oracle\ora92\rdbms\admin\catalog.sql
create or replace
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
create or replace
*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
The database is running know but for only queries and DML statements but
I cant able to run PL/SQL stuff.
I can't even able to export the data.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|