URGENT Oracle ERROR!!!

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Mon, 19 Mar 2001 00:52:45 -0800
Message-ID: <F001.002D03F0.20010319000521@fatcity.com>

Hello All,  

J ust now i got a error select count(*) from s_org_ext.  

SQLWKS> select count(*) from s_org_ext; where S_org_ext is Name of the Table.
COUNT(*)

---

ORA-01115: 
ORA-01110:  4: /db/oracle/oradata/tlisuser/data03.dbf 
ORA-27072: skgfdisp: 

SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262132  

But When I do select x,y,z,t,..... from s_org_ext then No error occured.  

The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is 1mb.  

Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6  

Developped got this error while executing a procedure. I think that procedurte will be insert into data into s_org_ext.  

PLease tell me what i will do. I think datafile will be damagaed. can not coiped on OS prompt when last time I took backup.  

Please help me.,

Regards,
Saroj.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dash, Saroj (CAP,CEF)
  INET: Saroj.Dash_at_gecapital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Mar 19 2001 - 02:52:45 CST