Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace Dictonary to Local conversion problem

594902Mar 25 2010 — edited Sep 27 2013
ORACLE - 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2013
Added on Mar 25 2010
11 comments
2,519 views