|
-
After migrating a dictionary managed tablespace to
locally managed tablespace
you notice that the tables are still extending with the next extent specified
even though it's now a locally managed tablespace
Migrated tablespaces are not subject to the UNIFORM/SYSTEM policy of newly
created locally managed tablespaces.
I would like to create new tablespaces and then
alter table T move tablespace NEW_TBS;
alter index I rebuild tablespace NEW_TBS;
Issue here is
*************
I wanted a list of tables which should be moved to get the full benefit of
locally managed tablespace.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|