Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 9 of 17
storage_clause: See "storage_clause".
partitioning_clauses: See "ALTER TABLE".
To alter the storage characteristics, refresh mode or time, or type of an existing materialized view log. A materialized view log is a table associated with the master table of a materialized view.
The terms snapshot and materialized view are synonymous. Both refer to a table that contains the results of a query of one or more tables, each of which may be located on the same or on a remote database.
See Also:
|
Only the owner of the master table or a user with the SELECT
privilege for the master table can alter a materialized view log.
See Also:
Oracle8i Replication for detailed information about the prerequisites for |
schema |
is the schema containing the master table. If you omit schema, Oracle assumes the materialized view log is in your own schema. |
|
table |
is the name of the master table associated with the materialized view log to be altered. |
|
physical_attributes_clause |
changes the value of |
|
partitioning_clauses |
The syntax and general functioning of the partitioning clauses is the same as for the Restrictions: |
|
parallel_clause |
specifies whether parallel operations will be supported for the materialized view log. For additional information, see the Notes to the parallel_clause of "CREATE TABLE". |
|
|
|
specifies serial execution. |
|
|
causes Oracle to select a degree of parallelism equal to the number of CPUs available on all participating instances times the value of the |
|
|
specifies the degree of parallelism, which is the number of parallel threads used in the parallel operation. Each parallel thread may use one or two parallel execution processes. Normally Oracle calculates the optimum degree of parallelism, so it is not necessary for you to specify integer. |
|
specifies the logging attribute. For information about specifying this attribute, see "ALTER TABLE". |
|
allocate_extent_clause |
explicitly allocates a new extent for the materialized view log. See Also: "ALTER TABLE". |
|
|
For data that will be accessed frequently,
See Also: "ALTER TABLE" for information about specifying |
|
|
augments the materialized view log so that it records the primary key values or rowid values when rows in the materialized view master table are updated. This clause can also be used to record additional filter columns. To stop recording any of this information, you must first drop the materialized view log and then re-create it. Dropping the materialized view log and then re-creating it forces each of the existing materialized views that depend on the master table to complete refresh on its next refresh. |
|
|
|
specifies that the primary-key values of all rows that are updated should be recorded in the materialized view log. |
|
|
specifies that the rowid values of all rows that are updated should be recorded in the materialized view log. |
|
filter_column(s) |
specifies that the values of these columns should be recorded in the materialized view log for all rows that are updated. Filter columns are non-primary-key columns referenced by materialized views. For information about filter columns, see Oracle8i Replication. |
|
specifies whether Oracle saves both old and new values in the materialized view log. |
|
|
|
saves both new and old values in the log. If this log is for a table on which you have a single-table materialized aggregate view, and if you want the materialized view to be eligible for fast refresh, you must specify |
|
|
disables the recording of new values in the log. You can use this clause to avoid the overhead of recording new values. However, do not use this clause if you have a fast-refreshable single-table materialized aggregate view defined on this table. |
The following statement changes the MAXEXTENTS
value of a materialized view log:
ALTER MATERIALIZED VIEW LOG ON dept STORAGE MAXEXTENTS 50;
The following statement alters an existing rowid materialized view log to also record primary key information:
ALTER MATERIALIZED VIEW LOG ON sales ADD PRIMARY KEY;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|