Home » RDBMS Server » Server Administration » from dictionary to locally (database ,9.2.0.8 ,solaris 10)
from dictionary to locally [message #569947] Sat, 03 November 2012 10:42 Go to next message
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
Michel Cadot
Messages: 68624
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

Previous Topic: SYS Invalid Objects
Next Topic: memory consumption - Insert script
Goto Forum:
  


Current Time: Thu Mar 28 05:47:35 CDT 2024