-
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
-
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|