-
Hello all ,
today i was defragmenting my fragmented tables .....
i defragmented my objects by
1) taking a full export of the user
2) dropping the user (cause a lot of the objects in this user were fragmented)
3) recreating the user (this user had a locally managed tablesapce as its default tablespace)
4) importing the users' object back.
now i ran my query (to check for fragmentation) again , but saw that the object showed the same fragmentation intensity.
now this was a peculiar site , as i had done this before , and got the desired defragmentation.
So now what i did was ,
1) i droped the user again.
2) i droped the locally managed tablespace
3) i recreated the user with a dictionary managed tablespace as its default tablespace.
4) i imported the users objects
this time i ran the query and found that the objects were defragmented (and i was happy again)
So here i concluded that when objects are stored in a locally manged tablespace , they cannot be defragmented , but when they are stored in a dictonary managed tablespace , they can be defragmented.
PLEASE EXPLAIN THE ABOVE PHENOMENON , IF POSSIBLE
Amit Sanghvi
Oracle DBA
Lex/Mastek
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
|