| raj |
Posted: Aug 09, 2007 03:34:38 AM |
Total Post: 15
Joined: Aug, 2007
|
i have create some tablespace
TABLESPACE_NAME STATUS CONTENTS EXTENT_MAN SEGMEN
------------------------------ --------- --------- ---------- ------
SYSTEM ONLINE PERMANENT DICTIONARY MANUAL
RAJ ONLINE PERMANENT DICTIONARY MANUAL
RAJ1 ONLINE TEMPORARY LOCAL MANUAL
RAJ3 ONLINE TEMPORARY LOCAL MANUAL
TAS1 ONLINE TEMPORARY LOCAL MANUAL
T1 ONLINE UNDO LOCAL MANUAL
im migrating system tablespace dictionary to local but i got
some error
ERROR at line 1:
ORA-10647: Tablespace other than SYSTEM,T1, RAJ1 not found in read only mode
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1
plz solve this |
|
|
 Mohammed Taj |
| Posted: Aug 09, 2007 04:01:32 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
<quote>
All tablespaces other than the tablespace containing the undo space (that is, the tablespace containing the rollback segment or the undo tablespace) are in read-only mode.
</quote>
Make all tablespace in READ ONLY mode except UNDO TBS.
and try your operation.
|
|
|
|
|
| jogi |
| Posted: Aug 29, 2007 02:29:51 AM | |
|
Total Post: 21
Joined: Jul, 2007
|
migrating from dictionary managed to locally managed tablespace:
if the system tablespace is dictionary then it is possible to migrate non system tablespace from locally to dictionary or dictionary to locally.
If the system tablespace is locally managed then it is not possible to migrate the non system tablespace from locally to dictionary is not possible.
Script for migrating the tablespace from dictionary to local:
sql> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('xyz');
script for migrating from locally to dictionary
sql> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('xyz');
thanks
prasad
oracle dba
9886241382
tooracledba@gmail.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
