Transporting Dictionary Managed Tablespace to 10g

thtsang_yh@yahoo.com.hk · *nix forums beginner Joined: 02 Jun 2005 Posts: 7

I am migrating some 8i data to 10g R2. The tablespaces in 8i database
are dictionary managed. For the 10g, everything is locally managed.

I used transportable tablespace export / import and was able to plug
the tablespace from 8i to 10g. The problem is that the tablespaces are
read only after TTS import. When I try to turn it read write:

SQL> alter tablespace traind read write;
alter tablespace traind read write
*
ERROR at line 1:
ORA-12915: Cannot alter dictionary managed tablespace to read write

Trying to turn it to LMT:

SQL> exec dbms_space_admin.tablespace_migrate_to_local('TRAIND');
BEGIN dbms_space_admin.tablespace_migrate_to_local('TRAIND'); END;

*
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 227
ORA-06512: at line 1

So it needs to be locally managed to make it read write, but to make it
read write, it must be locally managed.

Any solution? I dare not touch the 8i database.

Sybrand Bakker · *nix forums Guru Joined: 03 Apr 2005 Posts: 1766

On 20 Jul 2006 21:24:58 -0700, thtsang_yh@yahoo.com.hk wrote:

Google