| from dictionary to locally [message #569947] |
Sat, 03 November 2012 10:42  |
 |
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  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
