’YYYY-MM-DD’))
,partition item84 values less than (MAXVALUE)
)
with rowid
(
l_shipdate ,
l_returnflag ,
l_linestatus ,
l_quantity ,
l_extendedprice ,
l_discount ,
l_tax ,
l_suppkey ,
l_partkey ,
l_orderkey
)
including new values
;
Rem
Rem create the materialized view mav40 (see mav40.sql)
Rem snapshot logs must be there before creating the mav
Rem
alter session enable parallel dml;
insert into lineitem select * from temp_item_3 /* 179,000 Rows */;
commit;
execute dbms_snapshot.refresh(’MA40’);
****************************************************************************
pl/sql
|
