Tablespace Dictonary to Local conversion problem
594902Mar 25 2010 — edited Sep 27 2013ORACLE - 10.2.0.1.0
WINDOWS XP SP3
Sir,
On above platform I have created a db. I see that extent management of SYSTEM Tbs is Dictionary while other are Local.
To make system I fired the command..
exec dbms_space_admin.Tablespace_Migrate_TO_Local('SYSTEM');
I found the error that :
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
To solve this I google and found this :
http://www.orafaq.com/node/3
On following the steps I finally found this problem on firing this command :
SQL> select comp_name, version, status from dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
----------------------------------------
VERSION STATUS
------------------------------ -----------
Oracle Database Catalog Views
10.2.0.1.0 INVALID
Oracle Database Packages and Types
10.2.0.1.0 INVALID
So, I request to please guide what should I do now to resolve the problem.
Regards
Neeraj