Read Pro Oracle Database 11g Administration for Free Online

...................................................................................................... 349
    Loading a Regular Table from the External Table .............................................................................. 349
    Performing Advanced Transformations ...................................................................... 350
    Viewing Text Files from SQL ....................................................................................... 352
    Unloading and Loading Data Using an External Table ................................................ 354
    Using Parallelism to Reduce Elapsed Time ........................................................................................ 356
    Compressing a Dump File .................................................................................................................. 356
    Encrypting a Dump File ...................................................................................................................... 356
    Preprocessing an External Table ................................................................................ 357
    Summary ..................................................................................................................... 359
    ■Chapter 15: Materialized Views ........................................................................ 361
    Understanding Materialized Views ............................................................................. 361
    Materialized View Terminology .......................................................................................................... 363
    Referencing Useful Views .................................................................................................................. 364
    Creating Basic Materialized Views .............................................................................. 365
    Creating a Complete-Refreshable Materialized View ......................................................................... 365
    Creating a Fast-Refreshable Materialized View ................................................................................. 369
    Going Beyond the Basics ............................................................................................ 374
    Creating MVs and Specifying Tablespace for MVs and Indexes ........................................................ 374
    Creating Indexes on MVs .................................................................................................................... 374
    Partitioning Materialized Views ......................................................................................................... 375
    Compressing a Materialized View ...................................................................................................... 376
    Encrypting Materialized View Columns .............................................................................................. 376
    Building a Materialized View on a Prebuilt Table ............................................................................... 377
    xviii

    ■ CONTENTS
    Creating an Unpopulated Materialized View ...................................................................................... 378
    Creating a Materialized View Refreshed on Commit .......................................................................... 378
    Creating a Never-Refreshable Materialized View .............................................................................. 379
    Creating Materialized Views for Query-Rewrite ................................................................................. 380
    Creating a Fast-Refreshable MV Based on a Complex Query ............................................................ 381
    Viewing Materialized View DDL ......................................................................................................... 383
    Dropping a Materialized View