SQL & PL/SQL

HIII

ACTUALLY i have two question
1>

what is use of
ON PREBUILT TABLE clause that we use in a materialized view and added advantage



2>
actually i create a table fagga_pr and then a materialized view on that like this


SQL> ed
Wrote file afiedt.buf

1* create table fagga_pr (no number,name varchar2(2
SQL> /

Table created.

SQL> ed
Wrote file afiedt.buf

1 CREATE MATERIALIZED VIEW fagga_pr
2 ON PREBUILT TABLE WITH REDUCED PRECISION
3 ENABLE QUERY REWRITE
4 AS SELECT no,name
5* from fagga
SQL> /

now i refreshed it using

execute dbms_mview.refresh( list => 'FAGGA_PR', method => 'C' );

SQL> SELECT * FROM FAGGA_PR;

no rows selected


i dont know y even thoug i had data data in fagga

regards

Edited by: 810345 on Dec 23, 2010 8:03 PM