首页 > 应用开发 > IT综合 > Export Parameter : Query

Export Parameter : Query

原创 IT综合 作者:tsinglee 时间:2007-09-10 14:58:12 0 删除 编辑

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.


n The parameter QUERY cannot be specified for full, user, or tablespace mode


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.


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量