Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating Idex issue

Status
Not open for further replies.
gatetec

gatetec

MIS
Mar 22, 2007
420
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
 
Sort by date Sort by votes
Did you get an error message when it timed out ? Was it a locking issue or something else ?
 
Upvote 0 Downvote
What happens if you create the index without the compute statistics clause?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
Data fetch issue thru PL/SQL developer
Replies
4
Views
203
rk68
rk68
DeShaun
  • Locked
  • Question
Having issue with ORA 00920. sql works when run seperately
Replies
3
Views
171
Beilstwh
Beilstwh
rk68
  • Locked
  • Question
update query issue
Replies
3
Views
301
ChrisHunt
ChrisHunt
jamesflowers1974
  • Locked
  • Question
a question about creating a group in oracle SQL
Replies
1
Views
176
johnherman
johnherman
Andrzejek
  • Locked
  • Question
WHERE and HAVING issue 1
Replies
4
Views
138
cmmrfrds
cmmrfrds

Part and Inventory Search

Sponsor

Back
Top