Re: can't create index

Sounds like you might have a corrupt block. Have you tried DBVERIFY and any of the OS disk checking tools you might have to see if they can detect an error.

Only other thing that springs to mind is a privilege problem, but this sounds a bit too specific for that. Have you tried creating other indexes? Do they work - especially if they go any where near the same block?

MotoX.

On Wed, 16 Dec 1998 20:30:01 GMT, steve_young_at_my-dejanews.com wrote:

>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:53:36 CST