Wednesday, June 11, 2008

RUPD$_ TABLES

When we create materialized view log using primary key,
that oracle creates TEMPORARY TABLE => RUPD$_ :

They created for Java RepAPI.

Example:
> CREATE MATERIALIZED VIEW LOG ON TABLE_NAME WITH PRIMARY KEY;

> SELECT * FROM TAB;

TABLE_NAME TABLE
MLOG$_TABLE_NAME TABLE
RUPD$_TABLE_NAME TABLE

DESC MLOG$_TABLE_NAME

Name Null? Type
----------------------------------------------------------------- --------
ID NUMBER(10)
SNAPTIME$ DATE
DMLTYPE$ VARCHAR2(1)
OLD_NEW$ VARCHAR2(1)
CHANGE_VECTOR$ RAW(255)


DESC RUPD$_TABLE_NAME

Name Null? Type
----------------------------------------------------------------- --------
ID NUMBER(10)
DMLTYPE$ VARCHAR2(1)
SNAPID NUMBER(38)
CHANGE_VECTOR$ RAW(255)


...

No comments: