Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transporting Dictionary Managed Tablespace to 10g

Re: Transporting Dictionary Managed Tablespace to 10g

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 21 Jul 2006 07:19:22 +0200
Message-ID: <dso0c2pjuvv3697jr9gp870blm1qllo4ie@4ax.com>


On 20 Jul 2006 21:24:58 -0700, thtsang_yh_at_yahoo.com.hk wrote:

>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.

create a new locally managed tablespace in the 8i database. Set up a new user, with the locally managed tablespace as default tablespace
exp/imp fromuser= touser the old tables. Now plug in the locally managed tablespace in 10g.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 21 2006 - 00:19:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US