Re: Help wanted - Hangs up when creating index

Have a look in the v$system_event view for library cache locks against the table.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Lane Shen wrote in message <38632512.18EC2F70_at_direct.ca>...
>We are using Oracle8i 8.1.5 on HPUX with partition option. We have a SQL
>
>statement to create table using partition method to store the primary
>key. After we created the new database, everyting was working fine
>including the statement mentioned above. After the database was running
>for some days, the statement could not work any more. It kept running
>forever. We seperated the statement to two parts. One is to create table
>
>and one is to alter table adding primary key constraint. The table was
>created but the other one to add constraint hanged there. Then we don't
>add this constraint, instead we created unique index on it. It still
>hanged. We tried to create non-unique index. It was the same thing.
>
>Any body encountered such problem before? Any body can help?
>
>Thanks in advance
>Lane
>
>
>
Received on Fri Dec 24 1999 - 03:15:39 CST