Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transporting Dictionary Managed Tablespace to 10g
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.
How much data is it? Can you just use regular exp/imp?
jg
-- @home.com is bogus. http://catless.ncl.ac.uk/Risks/24.35.html#subj9Received on Fri Jul 21 2006 - 17:28:25 CDT