OraFAQ Forum: Server Administration » Tablespace migration : Local to dictionary

Home » RDBMS Server » Server Administration » Tablespace migration : Local to dictionary

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace migration : Local to dictionary [message #219005]

Mon, 12 February 2007 09:12

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;

Report message to a moderator

Re: Tablespace migration : Local to dictionary [message #219009 is a reply to message #219005]

Mon, 12 February 2007 09:22

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: Tablespace migration : Local to dictionary [message #219129 is a reply to message #219009]

Tue, 13 February 2007 02:17

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;

Report message to a moderator

Re: Tablespace migration : Local to dictionary [message #219502 is a reply to message #219005]

Wed, 14 February 2007 11:56

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

Report message to a moderator

Previous Topic:	ora-03134 when connecting from 10gR2 to 8.1.7
Next Topic:	one query plz

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:29:49 CST 2024