| partition corruption [message #150241] |
Tue, 06 December 2005 21:50  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
hi guys: Here is my sincere request. Is there a way, I can make the local partitions corrupt in a table. We get sometimes error while loading on a partition table using sql*loader and we want to prevent it. For that we need to play with a partition table with corrupt partitions. As far I know, it is easy to make local index partitions corrupt (unusable) when splitting, merging or say exchanging the data partitions. However it does not translate to the corruption in the local table partitions.
Any help/suggestion/advice will be very much appreciated.
ps:can any one tell me which site/forum would be good for unix/NT scripting related questions.
|
|
|
|
|
|
| Re: partition corruption [message #150365 is a reply to message #150352] |
Wed, 07 December 2005 10:17  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
You are right and we need to take care to prevent the corruptions occurring in partitions. However to test our steps to prevent partition corruption, we need a couple of partitions that we can implicitly make corrupt and then apply our steps to see if it works or not to correct the corruption. Also we need to find out what makes the partitions corrupt (test and validate it) and so we could prevent it from occurring.
thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
