Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> can't create index

can't create index

From: <steve_young_at_my-dejanews.com>
Date: Wed, 16 Dec 1998 20:30:01 GMT
Message-ID: <759585$2k8$1@nnrp1.dejanews.com>


When I create the index, I got the following error. Can u tell me what happen? The table is loaded with data by sqlldr. I didn't do anything on it before I create the index...

Thanks!!

Steve

CREATE INDEX i1 on t1(f1,f2);

                                 *

ERROR at line 1:
ORA-01115: IO error reading block from file 7 (block # 1048606)
ORA-01110: data file 7: '...../DATAFILES/usr.ora'
ORA-27072: skgfdisp: I/O error

SVR4 Error: 48: Operation not supported Additional information: 1048574

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 14:30:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US