Oracle encountered a ORA-04063 when creating a Job SYS. DBMS_INTERNAL_LOGSTDBY solution on the project you need to use the job to reset the sequence at the beginning of each month, on my local Oracle the job was created successfully,
But in the project test platform to create but reported the ORA-04063 error, see: search on the Internet, someone said to re-compile DBMS_INTERNAL_LOGSTDBY package body, tried, after the compilation is still wrong. View DBMS_INTERNAL_LOGSTDBY in PL/SQL at www.2cto.com and find that the view "DBA_LOGSTDBY_PROGRESS" on which it depends has an error. Open the DDL statement "DBA_LOGSTDBY_PROGRESS" and run it. logmnr_session $ "error: after searching, I found that the system user does not have the logmnr_session $ table, so I copied the system from other databases. run the DDL Statement of logmnr_session $. Then execute "DBA_LOGSTDBY_PROGRESS"
Still report error: view the DDL Statement of LOGSTDBY_LOG, and execute: The system. logmnr_log $ cannot be found, and then copy system. logmnr_log $ from other databases.
Run the DDL statement and create LOGSTDBY_LOG. The result is: The Red Cross on the visible "LOGSTDBY_LOG" does not exist, and it depends on "DBA_LOGSTDBY_PROGRESS"
It is also normal. This resolves "DBA_LOGSTDBY_PROGRESS" in the "DBMS_INTERNAL_LOGSTDBY" package dependency error ". Www.2cto.com looked back and found that there was still an error in its dependency. This is the view "DBA_LOGSTDBY_LOG": the DDL Statement of "DBA_LOGSTDBY_LOG" was successfully re-executed. No error was reported, but the Red Cross is still there,
Recompile it and the Red Cross disappears. Then re-compile "DBMS_INTERNAL_LOGSTDBY". It is also normal,
This solved the "ORA-04063" error. Next, create a job to verify that the job is successfully created. The key to this bypass is the lack of the system. logmnr_session $ and system. logmnr_log $ tables. Author cuihaiyang