Re: Online redef - is there a better way?

From: Ind-dba <>
Date: Sun, 15 Feb 2009 00:54:51 -0800 (PST)
Message-ID: <>

Thanks Jonathan for your reply!

While doing FINISH redef -- i saw wait event "Wait for Table Lock" -- does that means that oracle will wait for table lock? And if we wait
-- we can avoid ORA-54? what do you say ?

  1* select username,event,b.object_name from v$session, dba_objects b where username='SYSTEM' and ROW_WAIT_OBJ#=b.object_id; SQL> / USERNAME

SYSTEM                         Wait for Table
Lock                                              TABLE_1

1 row selected.

  • Sachin
Received on Sun Feb 15 2009 - 02:54:51 CST

Original text of this message