Home » RDBMS Server » Server Administration » can't migrate from dictionary to locally managed
can't migrate from dictionary to locally managed [message #271958] Wed, 03 October 2007 08:23 Go to next message
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 #271962 is a reply to message #271958] Wed, 03 October 2007 08:33 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello matisse,


Read this please.
http://www.orafaq.com/forum/mv/msg/88600/265591/110238/#msg_num_7

Regards,


mson77
Re: can't migrate from dictionary to locally managed [message #271964 is a reply to message #271958] Wed, 03 October 2007 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you check you satisfy all conditions enumerate at: SYSTEM Tablespace Migration: Conditions

Regards
Michel
Re: can't migrate from dictionary to locally managed [message #271970 is a reply to message #271962] Wed, 03 October 2007 09:01 Go to previous messageGo to next message
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,
Re: can't migrate from dictionary to locally managed [message #271971 is a reply to message #271970] Wed, 03 October 2007 09:04 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello matisse,

Thank you for your feedback!
I appreciate a lot your relevant information,

Regards,


mson77
Re: can't migrate from dictionary to locally managed [message #271986 is a reply to message #271970] Wed, 03 October 2007 10:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course! I didn't see 9.0.
This version is really bad, the worst you can find. Upgrade to 9.2 or better 10.2.

Regards
Michel
Previous Topic: DB Admin-UTL_MAIL.SEND execution
Next Topic: Kernal Parameters VS RAM in Intalling 10.2.0.1
Goto Forum:
  


Current Time: Sat Dec 10 22:40:20 CST 2016

Total time taken to generate the page: 0.04458 seconds