Subject | Store a table in a another datafile |
---|---|
Author | Ramiro Barreca |
Post date | 2009-08-10T13:14:25Z |
We have a hugh database of more than 10 GB that usually became corrupted,
but we cannot repair it with a simple gfix command.
In this database there is a table with over 50 million records that grows up
at 130000 records/month. This is the one we suspect is the problem of
corruptions.
We think it would be better to have this table on another datafile that we
can repair on a better way.
We have seen that we can create a second datafile, but how to transfer only
this database to the new one?
Thanks in advance.
Ramiro Barreca
[Non-text portions of this message have been removed]
but we cannot repair it with a simple gfix command.
In this database there is a table with over 50 million records that grows up
at 130000 records/month. This is the one we suspect is the problem of
corruptions.
We think it would be better to have this table on another datafile that we
can repair on a better way.
We have seen that we can create a second datafile, but how to transfer only
this database to the new one?
Thanks in advance.
Ramiro Barreca
[Non-text portions of this message have been removed]