DBA_APPLY_PROGRESS view apply message time is set to 01-JAN-88 (Doc ID 1364586.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

After setting up a new streams set up, the column  applied_message_create_time in view dba_apply_progress is set to 01-JAN-88.


SQL> select APPLY_TIME,APPLIED_MESSAGE_CREATE_TIME from dba_apply_progress;

APPLY_TIME     APPLIED_MESSAGE_CREATE_TIME
---------           ----------------------------
01/JAN/88        01/JAN/88

Changes

Newly created Streams Apply.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms