Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Materialized Views


u1> create materialized view mviewvenu
refresh fast
with primary key
start with sysdate
next sysdate + 1/(24*60*60)
as select * from dept;
u1> save m.sql
u1> conn / as sysdba
SQL> grant create materialized view to u1;
SQL> conn u1/u1
u1> @m.sql

oracle@venu1> export ORACLE_SID=venu
oracle@venu1> sqlplus / as sysdba
SQL> conn scott/tiger
scott> create materialized view log on dept;
scott> select * from tab;

u1> @m.sql --> run in client
u1> select * from tab;
u1> select * from mviewvenu;

scott> insert into dept values(50,'dba','hyd'); --> run in server
scott> select * from mlog$_dept;

u1> select * from mviewvenu; --> client

scott> commit ---> server

u1> select * from mviewvenu; --> client

scott> select * from mlog$_dept; --> server

Related Posts Plugin for WordPress, Blogger...

Flag Counter