Materialized View Error

[kris123]

Hi Friends,

DB = Oracle 8i
OS = AIX 4.3.2

I have a table EMP which i created a materialized view log (MLOG$_EMP) for replication purposes. The materialized view log is based on the primary-key EMPNO.

SQL> alter session set nls_date_format ="DD-MON-YYYY HH:MI:SSAM";

Session altered.


SQL> SELECT EMPNO,SURNAME FROM EMP WHERE EMPNO='0001';

EMPNO SURNAME
------- ---------
0001 SINFUENTE

SQL> SELECT * FROM MLOG$_EMP WHERE EMPNO='0001';

no rows selected

SQL> UPDATE EMP SET SURNAME=SURNAME WHERE EMPNO='0001';

1 row updated.

SQL> SELECT * FROM MLOG$_EMP WHERE EMPNO='0001';

EMPNO SNAPTIME$$ D O CHANGE_VECTOR$$
-------- ---------------------- - - ----------------
0001 01-JAN-4000 12:00:00AM U U 08000000000000


SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
----------------------
22-DEC-2004 10:50:44AM


.....My question is why the SNAPTIME$$ is defaulted to 01-JAN-4000?
all my updates and inserts have all the same snaptime 01-JAN-4000 12:00:00AM...


Can you help me please....
Thanks a lot

[kris123]

goodbye FJP :(

[akhadar]

check the following link
http://metalink.oracle.com/metalink/...p_id=1068195.6

[kris123]

Thanks hun