ORA-01200: need to correct datafile header
117914Jan 21 2004 — edited May 25 2011Hi:
I was making a bulk load into my database when occurred a power failure. Now, when I try to start the database I receive the message:
ORA-01200: actual file size of 1569280 is smaller than correct size of 1569920 (blocksize = 4K),
and the database does not open. As I understand, the datafile (autoextend) was growing, the datafile header has been updated, but not the datafile in itself.
I ran dbverify (dbv) and the datafaile is PERFECT, but there is no way to make Oracle understand this.
I cannot recreate the control files because the datafile header is inconsistent with its os size.
IS THERE A WAY TO UPDATE THE DATAFILE HEADER? If I could do so, I could save the database.
Thanks in advance.