Apply and Activate on Local Database causes Tools Application to Hang
Connected to the local database with the user id and password for the local user; while applying with the correct ODBC connection and the process initiates for a minute, and then Siebel tools automatically closes; In another machine, the process initiates and the application hangs forever, tried giving many other options w.r.t different user id's and passwords but did not work. Also tried out with SIEBEL/Local user Password, DBA/Enterprise Server Name and all in vain. The application just hangs without throwing any error message.
It was found that during an "Apply" a Siebel DUMMY table is created within the Oracle db then dropped after the Apply completes.
It seems that due to a previous 'Apply' not completing successfully this DUMMY table still existed.
Therefore the error received when attempting to apply the new table.
The exact table name = SIEBEL.D_U_M_M_Y
To resolve this the DUMMY table was dropped using database utilities
NOTE:This Tip appliesto Siebel Tools - Version: 126.96.36.199 SIA  and later [Release: V7 and later] and it is recommended solution by Siebel