| can't migrate from dictionary to locally managed [message #271958] |
Wed, 03 October 2007 08:23  |
matisse
Messages: 2
Registered: October 2007
|
Junior Member |
|
|
Hi all,
I have problem with the dictionary managed SYSTEM tablespace. We have one Windows server 2003 with ORACLE 9.0.1.4 running on it. I've migrated all the tablespaces (except SYSTEM) from dictionary to locally managed. Now I'm trying to migrate the SYSTEM tablespace,but not able to do it.
SQL> shutdown immediate
SQL> startup restrict
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('SYSTEM');
ERROR at line 1:
ORA-03245: Tablespace has to be dictionary managed, online and permanent
to be able to migrate
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1
I confirmed that system tablespace is already dictionary managed,online and permanent.So I don't understand why I'm not allowed to change it?
Thanks in advance
|
|
|
|
|
|
|
|
| Re: can't migrate from dictionary to locally managed [message #271970 is a reply to message #271962] |
Wed, 03 October 2007 09:01  |
matisse
Messages: 2
Registered: October 2007
|
Junior Member |
|
|
Hi again,
Actually I followed the instructions in Metalink Note:175434.1.
I checked your post and to be sure I did all the steps again,it's still the same. But the message I got is not related with user tablespaces status,cause I've already put them in Read-only mode. Then I saw a point - which I missed before - in that Metalink note,saying 'Locally managed SYSTEM tablespaces are simply not possible until 9.2' I think that's my problem is.
Sorry for taking your time and thanks for all your help..
Regards,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
