Jan 23, 2008 #1 gatetec MIS Joined Mar 22, 2007 Messages 420 Location US 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
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
Jan 23, 2008 #2 Dagon MIS Joined Jan 30, 2002 Messages 2,301 Location GB Did you get an error message when it timed out ? Was it a locking issue or something else ? Upvote 0 Downvote
Jan 23, 2008 #3 jimirvine Instructor Joined Mar 18, 2005 Messages 280 Location GB What happens if you create the index without the compute statistics clause? Upvote 0 Downvote