from dictionary to locally [message #569947] |
Sat, 03 November 2012 10:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8946521eea1cefbefa58c3f1c2e8c015?s=64&d=mm&r=g) |
tamer_abou7
Messages: 1 Registered: November 2012 Location: egypt
|
Junior Member |
|
|
dear all
i need help
i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i recieved errors
SQL> alter tablespace APPLSYSD READ ONLY;
alter tablespace APPLSYSD READ ONLY
*
ERROR at line 1:
ORA-01230: cannot make read only - file 636 is offline
ORA-01111: name for data file 636 is unknown - rename to correct file
ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636'
i have not this file on the OS
|
|
|
Re: from dictionary to locally [message #569955 is a reply to message #569947] |
Sat, 03 November 2012 13:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
MISSING00636 is a generic name for file number 636 is missing you have to give the actual name of the file.
If you have not this file then you have to create a new (locally maneged) tablespace and move all objects into it.
Note that it is FAR FAR better to create a new database with SYSTEM tablespace (and all other ones) locally managed and import the old database into it. When you change a DMT to a LMT it is then NOT a real LMT, it is a chimera.
Regards
Michel
[Updated on: Sat, 03 November 2012 13:07] Report message to a moderator
|
|
|