Holly.
I look for your errors descriptions
$ oerr ORA 01115
01115, 00000, "IO error reading block from file %s (block # %s)"
// *Cause:  Device on which the file resides is probably offline
// *Action: Restore access to the device
$ oerr ORA 01110
01110, 00000, "data file %s: '%s'"
// *Cause:  Reporting file name for details of another error
// *Action: See associated error message
$ oerr ORA 27069
27069, 00000, "skgfdisp: attempt to do I/O beyond the range of the file"
// *Cause:  internal error, the range of blocks being read or written is
//          outside the range of the file, additional information indicates
//          the starting block number, number of blocks in I/O, and the
//          last valid block in the file
// *Action: check for trace file and contact Oracle Support

I think that you need to run next command as sysdba
"alter tablespace <YOUR_TABLESPACE_NAME> add file 
'NEW_FILE_PATH_FOR_TABLESPACE' "

> OS:WIN2K
> DB:Oracle 9.0.1 (ArchiveLog & Production)
>
> I'm facing those error with one my datafile. The datafile is >4GB. The
> datafile is in autoextend mode, so I don't aware about the datafile
> increasing, until suddenly database down:( Unfortunetly, I've no backup at
> all also. The person who responsible to do offline backup never backup the
> database. Some archive log is missing also:(
>
> Please help me, to solve the problem. Any comment or suggestion I would
> appreciate.
>
> thank in advance,
> ~holly~

-- 
Best regards
Michael Ivanov, TD "ERA"
��zǞ��}����ND��@Bm����
+i��r����h�Ȝ���"����
9�����^����B�܍z�(�D����z�9���Nu��i��0���r+rr��jp�z
jX����hƢ�)��+-jwpy�h�ا�ǫ�'�:Õ*.�ǥ}���b�f��)��+-���jq
j)fz���h.+-��}�\�ܜ�i��$��e�x(|���k���݊{azg����؊w%�ך�)�r��j)�
I@ND��+��jg�~f��)��+-ʋ�j{m���zj/y��f(�f�j[(��ݶ��ܢi���讋az��~��jب�X�z˛���n)�


Reply via email to