Re: Urhent help needed: import shuts down database

        Sounds like you have a corrupted datafile. To be on the safe side I suggest that you export every table that is stored in the tablespace the datafile belongs to and plan on cleaning up your disk problem and then rebuilding the tablespace. (I say this because if you have been getting the error for a while you probably can't recover from your backups.)

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/17/00, 5:41:07 PM, yong321_at_yahoo.com wrote regarding Urhent help needed: import shuts down database:

> My import frequently aborts and shuts down the database. Here's the
> error in alert log:
 

> KCF: write/open error block
> file /hwh/oradata/logician7.dbf
> error'072 txt: 'SVR4 Error: 5: I/O error
> Additional information: 14174'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 4014
 

> The import parameter file specifies commit=y, buffer24000,
 ignore=y,
> analyze=N, feedbackP000, among other things, using conventional

path.
> When the import aborts, I can always restart the database and rerun
> import, which aborts again after a while, at a different block number,
 

> but the same "error'072" and "error 1242". Trying many times I can
 

> eventually import successfully. The dump file is only 700 MB. I wonder
 

> if there's a disk failure. Please help.
 

> This is Oracle 8.1.6 on Solaris 7.
 

> Yong Huang
> Email: yong321_at_yahoo.com

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 18 2000 - 00:00:00 CDT