1. , , ;

2. Oracle Database 11g: New Features for Administrators 20 - 1 ; 3. Oracle Database 11g: New Features for Administrators 20 - 2 SELECT * FROM sales; SELECT * FROM customers; SELECT * FROM countries; -- , ; DROP VIEW sh.v_region_total_amount; 4. Oracle Database 11g: New Features for Administrators 20 - 3 -- , ; DROP MATERIALIZED VIEW LOG ON SH.SALES; DROP MATERIALIZED VIEW LOG ON SH.CUSTOMERS; DROP MATERIALIZED VIEW LOG ON SH.COUNTRIES; DROP MATERIALIZED VIEW SH.MV_REGION_TOTAL_AMOUNT; 5. Oracle Database 11g: New Features for Administrators 20 - 4 1. 1. BUILD DEFERRED: , . , , UNUSABLE; 2. BUILD IMMEDIATE: , ; 3. dba_mviews BUILD_MODE ; 2. : 6. Oracle Database 11g: New Features for Administrators 20 - 5 1. WITH : 1. , PRIMARY KEY, ROWID, OBJECT ID ; 2. OBJECT ID: ID; 3. PRIMARY KEY: ; 4. ROWID: ROWID; 7. Oracle Database 11g: New Features for Administrators 20 - 6 db_link ; ; ; PCT ; : 1. , rownum, sysdate, ;