| locally Managed tablespaces [message #54591] |
Fri, 22 November 2002 11:14  |
dennis Mello
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
I current have a dictionary managed table for my data.
I want to create 3 LMT of uniform size (lg,md,sm) to hold the data. When I move the tables to the appropriate LMT will they become resized with the uniform size? Is this the best way to accomplish my goal?
|
|
|
|
| Re: locally Managed tablespaces [message #54592 is a reply to message #54591] |
Fri, 22 November 2002 12:08  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Speaking from memory - no they don't get uniformly resized. If you export the objects and try to re-import them into the LMT's (some of this can be done by changing the default TS for the user) they retain their original extent sizes. You can convert the tablespaces to LMT using:
begin DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('MY_TABLESPACE'); end;
I think I got my tables rightsized by moving to a temp tablespace and then back again (alter table ABC move tablespace XYZ...). Same with indexes using rebuild (after moving tables not belore).
You may find that I'm not 100% accurate - this was some time ago.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
