How to Run REBUILD_SCHEMA on the instance?
Hi All ,
Engine failed with below log file and I can see one of the solution from Metalink is to Run REBUILD_SCHEMA on the instance .Can anyone help me to know how to run REBUILD_SCHEMA?
14:52:53:591 Calculated first forecast date: 2018-06-01 (17684)
14:52:53:592 Calculated last forecast date: 2019-11-01 (18202)
14:59:10:127 ERROR ---------------------------------------------------------------
14:59:10:127 ERROR DB_OracleCommand::Execute threw an exception. Error: 20002 ORA-20002: -54 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Error in PROCEDURE DROP_FORE_COL.DROP_FORE_COL line 324
dynamic_ddl( 'ALTER TABLE SALES_DATA DROP COLUMN FORE_2')
ORA-06512: at "DCIDEM.SEND_ERR_MESSAGE", line 35
ORA-06512: at "DCIDEM.DYNAMIC_DDL", line 44