From Saroj.Dash@gecapital.com Mon, 19 Mar 2001 00:52:45 -0800 From: "Dash, Saroj (CAP,CEF)" Date: Mon, 19 Mar 2001 00:52:45 -0800 Subject: URGENT Oracle ERROR!!! Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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).