Hi All,
We have oracle 11.2 on Aix.
Every weekend we do rebuild the indexes on non business hours.
while doing rebuild index,we got the error ORA-00054.ddl_lock_timeout is zero in the db.
Just i tried to reproduce the error ORA-00054 as below.
Session 1
-------------
create table test as select * from dba_objects;
create index ind_test on test (object_id);
Session 2
-------------
Insert into test select * from dba_objects;
NO rollback or commit is given.
Session 1
-------------
alter index ind_test rebuild online;
The session 1 seems to be hang for a long time.
then i gave rollback ,then session 1 is released.
How to reproduce the error ORA-00054 and is there any solution for that.
Any Suggestions
Thanks & Regards,