|
-
My thought would be -
1) keeping multiple datafiles will make sense only if you could span these files across several disks. this will give faster disk i/o.
2) Keeping them in separate datafiles or single datafile will hardly make a difference in case of corruption as it is recommended to take the complete index tablespace offline and recover. As partial availability leads to strange problems.
Hope it helps,
Regards,
- Niranjan
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
|