Read Pro Oracle Database 11g Administration for Free Online Page A

............................................................................................................ 384
    Modifying Materialized Views ..................................................................................... 385
    Modifying Base-Table DDL and Propagating to Materialized Views .................................................. 385
    Toggling Redo Logging on a Materialized View ................................................................................. 388
    Altering Parallelism ............................................................................................................................ 389
    Moving a Materialized View ............................................................................................................... 389
    Managing Materialized View Logs .............................................................................. 390
    Creating a Materialized View Log ...................................................................................................... 391
    Indexing Materialized View Log Columns .......................................................................................... 392
    Viewing Space Used by a Materialized View Log ............................................................................... 392
    Shrinking the Space in a Materialized View Log ................................................................................ 393
    Checking the Row Count of a Materialized View Log ......................................................................... 393
    Moving a Materialized View Log ........................................................................................................ 394
    Dropping a Materialized View Log ..................................................................................................... 395
    Refreshing Materialized Views ................................................................................... 395
    Manually Refreshing Materialized Views from SQL*Plus ................................................................... 396
    Automating Refreshes Using a Shell Script and Scheduling Utility .................................................... 397
    Creating an MV with a Refresh Interval ............................................................................................. 398
    Efficiently Performing a Complete Refresh ........................................................................................ 399
    Handling the ORA-12034 Error ........................................................................................................... 399
    Monitoring Materialized View Refreshes .................................................................... 400
    Viewing Materialized Views’ Last Refresh Times .............................................................................. 400
    Determining Whether a Refresh Is in Progress .................................................................................. 401
    Monitoring Real-Time Refresh Progress ............................................................................................ 401
    xix

    ■ CONTENTS
    Checking Whether MVs Are Refreshing Within a Time Period . .......................................................... 402
    Creating Remote Materialized View Refreshes . ......................................................... 403
    Understanding Remote-Refresh Architectures ................................................................................... 404
    Viewing Materialized View Base-Table Information ........................................................................... 405
    Determining How Many MVs Reference a Central MV Log . ............................................................... 406
    Managing Materialized Views in Groups . ................................................................... 408
    Creating a Materialized View Group .