Article Content
Article Number | 000028948 |
Applies To | Affected Versions: All Versions |
Issue | The following error is seen at the very end of running /home/oracle/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh, after all the database tables are loaded sucessfully. What does this error mean, and can it be 'ignored' ?
. . l Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW Processing object type SCHEMA_EXPORT/REFRESH_GROUP ORA-39083: Object type REFRESH_GROUP failed to create with error: ORA-23421: job number 5 is not a job in the job queue
Failing sql is:
BEGIN dbms_refresh.make('"AVUSER"."MV_SYSTEMAPPSSUMMARY"',list=>null,next_date=>null,interval=>null,implicit_destroy=> TRUE,lax=>FALSE,job=>5,rollback_seg=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0); dbms_refresh.add(name=>'"AVUSER"."MV_SYSTEMAPPSSUMMARY"',list=>'"AVUSER"."MV_SYSTEMAPPSSUMMARY"',siteid=>0,ex
Job "AVUSER"."AVDB_IMPORT_AVUSER" completed with 1 error(s) at 12:25:19 |
Resolution | These are the materialized views for the login page. |