This parameter allows you to select a subset of rows from a set of tables when doing
a table mode export. The value of the query parameter is a string that contains a
WHERE clause for a SQL SELECT statement that will be applied to all tables (or table
partitions) listed in the TABLE parameter.
If a table is missing the columns specified in the QUERY clause, an error message
will be produced, and no rows will be exported for the offending table.
Restrictions
n The parameter QUERY cannot be specified for full, user, or tablespace mode
exports.
n The parameter QUERY must be applicable to all specified tables.
n The parameter QUERY cannot be specified in a direct path export (DIRECT=y)
n The parameter QUERY cannot be specified for tables with inner nested tables.
n You cannot determine from the contents of the export file whether the data is
the result of a QUERY export.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-968764/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
