| conversion from dictionary managed tablespace to Local [message #173787] |
Wed, 24 May 2006 07:44  |
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
|
Member |
|
|
Hi
i convert a dictionary managed tablespace to Locally managed tablespace, after conversion what will be the extent allocation?
whether the extent allocation will be uniform?
Can anyone explain me examples?
Thanks
Anandhi
|
|
|
|
|
|
| Re: conversion from dictionary managed tablespace to Local [message #173838 is a reply to message #173818] |
Wed, 24 May 2006 15:14  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
you can easily convert to LMT, but be aware that original extents aren't rebuilt - you would need to alter table XYZ move..., alter index ABC rebuild...
dbms_space_admin.tablespace_migrate_to_local('MY_TS');
As usual - don't do this to system tablespace before researching. Take backup before converting tablespaces. I last did it in 8i and it worked fine.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
