ERR-9027 and ERR-9085 in replicate log files

Explain what ERR-9027 and ERR-9085 means

Problem Details

Problem Statement

Explain what ERR-9027 and ERR-9085 means

Applicable Error Code

ERR-9027, ERR-9085

Affected Versions

9

Affected Platforms

Linux & Windows

Description

Explain what ERR-9027 and ERR-9085 means and its impact on Replication.

2018/04/23 12:35:21 INFO> Replicate job Delete old records from DBRSCOMMON_ERRORLOG submitted as job 24487.
2018/04/24 00:46:33 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320002 not found at SCN 437357229904 at mine.
2018/04/24 00:46:33 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320002 does not exist, cannot unprepare.
2018/04/24 00:46:41 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320003 not found at SCN 437357233376 at mine.
2018/04/24 00:46:41 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320003 does not exist, cannot unprepare.
2018/04/24 00:47:12 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320004 not found at SCN 437357240830 at mine.
2018/04/24 00:47:12 ERROR> ERR-9027: Table SYS.ORA_TEMP_1_DS_2320004 does not exist, cannot unprepare.
2018/04/24 00:47:12 ERROR> ERR-9085: Table SYS.ORA_TEMP_1_DS_2320005 not found at SCN 437357240960 at mine.

Solution

These SYS.ORA_TEMP_1_DS_% temporary tables are used when Oracle computes statistics during the gathering of statistics.
Because they are used for the internal purpose of gathering statistics (internal usage of dbms_stats package), they are created in SYS schema. These tables can be then referenced in user schema when replication is active.

Having said that, these messages are ignorable.