Materialized View Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Materialized View Error

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    Materialized View Error

    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

  2. #2
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    goodbye FJP :(

  3. #3
    Join Date
    May 2001
    Posts
    736

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks hun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width