Creating Idex issue

[gatetec]

SQL> CREATE INDEX XIE3ACCESSION ON ACCESSION ( ACCESSION)
2 STORAGE ( INITIAL 16400K NEXT 2080K MAXEXTENTS 505 )
3 LOGGING TABLESPACE I_ACCESSION COMPUTE STATISTICS;

This statement hangs and timed out. What would the cause and how to fix this issue?

thx much

 

[Dagon]

Did you get an error message when it timed out ? Was it a locking issue or something else ?

 

[jimirvine]

What happens if you create the index without the compute statistics clause?