For Oracle Server: From an sqlplus session, connect
to the database using the DBA account and run the following command:
BEGIN
db_administrator_name.DW_MIGRATE('operational_data_store_schema_name','data_mart_schema_name','report_user_name');
end;
/
If you run the command again, only those database statements
are executed that failed earlier or are set to EXECUTE=1 with an execution
status of 0 or null.
To find out which statements were run, look in the CONFIG.STATEMENT_LIST
table for the RET_CODE column, and you can see the SQLSTSATE/SQLCODE
returned for the failed statements