-
tablespace fragmentation
If I have a HWM on the table, I move the tabes to different tablespaces using :
ALTER TABLE TABLE_NAME MOVE NEW_TABLESPACE;
what if I move the table on the same tablespace like:
ALTER TABLE TABLE_NAME MOVE;
the question is "is it bad thing to move the table on the same tablespace??? which may cause fragmentation on the tablespace b/c of the old segment???"
I am on 9i and using local extent
have a great weekend to all.
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
|