ORA-1653: Unable to extend table - causes corruption ?

From: Alan Black <alan_at_opcomp.demon.co.uk>
Date: Sat, 30 Jan 1999 08:17:54 +0000
Message-ID: <NnwDzBAyAss2EwCT@opcomp.demon.co.uk>

Oracle 8.0.5
Windows NT 4

I've just received the message ORA-1653 (unable to extend table) while SQL*Loading 7m records into a table.

This caused some other side effects such as Oracle reporting some objects as missing.

The problem is that on restarting the database after a shutdown, I'm getting ORA-01122 (database file failed verification check) and ORA- 01200 (actual file size is different). These are reported against the data file of the tablespace that I was loading into.

I can now only restore from backup.

I can live with the first error (although I don't think that there was any reason for it being unable to extend (plenty of free space and the data file/tablespace was setup for auto-extending), but It's concerning that this has corrupted a data file.

I've heard that there may be a problem with Oracle 8.0.5/NT with 4GB files and mine had just auto-extended to 4GB.

Anyone any ideas ?

Regards,
Alan.
--
Alan Black Received on Sat Jan 30 1999 - 02:17:54 CST