-
Hi Everyone,
I am reorganizing our tbsps following the "Stop Defragmenting and Start Living" Recommendation.
Steps I am taking.
Export - from user to user, compress=y
Import - from user to user, indexfile
Edit Indexfile with new storage parameters
Offline drop tbsps, delete os datafiles
Create new tbsps, with new storage parameters
Import - from user to user, rows=y, ignore=y, commit=y
Rebuild all Indexes
Analyze all objects
Recompile any invalid objects
Problem:
When I then query on user_indexes some system generated indexes are showing with different storage parameters (not the ones specified by the tbsp). How does this happen?
System generated indexes didn't show up in my indexfile?
When where they created and how did they come up with the different storage clauses?
Thanks
Kathy
-
Do you mean indexes owned by the SYS user ? These are never exported and you can't change the storage parameters associated with them.
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
|