dbTalk Databases Forums  

Migrating tablespace from dictionary managed to locally managed

comp.databases.oracle comp.databases.oracle


Discuss Migrating tablespace from dictionary managed to locally managed in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Shailesh
 
Posts: n/a

Default Migrating tablespace from dictionary managed to locally managed - 09-13-2004 , 04:07 AM






Metalink says that, whenever we migrate from dictionary managed to
locally managed tablespaces, 'Migrated tablespaces are not subject to
the UNIFORM/SYSTEM policy of newly created locally managed
tablespaces. you should see "USER" value in the ALLOCATION_TYPE column
for migrated tablespaces'.

Oracle documentation says that parameters like INITIAL, NEXT ,
MINEXTENTS, MAXEXTENTS will not apply to locally managed tablespaces.

Suppose I already have some objects, reaching their MAXEXTENT limit in
dictionary managed tablespace. After migrating to locally managed
tablespace, will they still give 'MAXEXTENTS reached error'?

I can specify all these parameters for newly created objects. In that
case, they will be accepted. But if I dont give these parameters what
will happen to newly created object? Will it behave like an object in
newly created locally managed tablespace?

Thanks,
Shailesh

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.