Home » RDBMS Server » Server Administration » Tablespace migration : Local to dictionary
Tablespace migration : Local to dictionary [message #219005] Mon, 12 February 2007 09:12 Go to next message
clioteux
Messages: 5
Registered: February 2007
Location: algiers
Junior Member

Hi,

Is there a possibility to migrate a tablespace from locally managed to dictionary managed;

Thanks;
Re: Tablespace migration : Local to dictionary [message #219009 is a reply to message #219005] Mon, 12 February 2007 09:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_spadm3.htm#1003370
But why?
Re: Tablespace migration : Local to dictionary [message #219129 is a reply to message #219009] Tue, 13 February 2007 02:17 Go to previous messageGo to next message
clioteux
Messages: 5
Registered: February 2007
Location: algiers
Junior Member

Thanks;

It's for studies and test purpose...

The students would like to test the storage clauses...

SY;
Re: Tablespace migration : Local to dictionary [message #219502 is a reply to message #219005] Wed, 14 February 2007 11:56 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Depends on the DB tablespace type.

If you have ALL the tablespaces converted to local, including SYSTEM, then you cannot change from LOCAL to DICTIONARY.

What this means is, as long as you have SYSTEM still as DICTIONARY managed and other tablespaces LOCAL or DICTIONARY, you can interchange them

If you have SYSTEM as LOCAL, then changing type is not allowed.
--
Sanjay
Previous Topic: ora-03134 when connecting from 10gR2 to 8.1.7
Next Topic: one query plz
Goto Forum:
  


Current Time: Sat Dec 03 22:34:32 CST 2016

Total time taken to generate the page: 0.06417 seconds