Oracle® Database Error Messages 11g Release 2 (11.2) Part Number E17766-02 |
|
|
Mobi · ePub |
1. The directory exists.
2. The name indeed points to a directory, and is not a file.
3. The directory is accessible and writable to the ORACLE user.
1. The directory exists.
2. The name indeed points to a directory, and is not a file.
3. The directory is accessible and writable to the ORACLE user.
1. The directory exists.
2. The name indeed points to a directory, and is not a file.
3. The directory is accessible and writable to the ORACLE user.
- DROP COLUMN, resubmit DROP COLUMN CONTINUE
- DROP TABLE, resubmit DROP TABLE <table> PURGE
- For ROWID materialized views, the master table's ROWID must be logged.
- For primary key materialized views, the master table's primary key columns must be logged.
- For subquery materialized views, the filter columns, primary key, and ROWID values must be logged.
- For object materialized views, object id must be logged.
* The materialized view is updatable
* The materialized view refreshes ON COMMIT
* Automatic refresh options are specified
o ROWID materialized views
o REFRESH ON COMMIT
o ON PREBUILT TABLE
o BUILD DEFERRED
o NEVER REFRESH
o ENABLE QUERY REWRITE
o The database link that will be used by the materialized view site to connect to the master site must be included with each master table referenced in the query.
o All master tables referenced must be located at the local site. References to other sites are not allowed.