Oracle Spatial Object Reader参数

选择现有连接或添加数据库连接to define a new connection.

The new connection can be made visible only to the current user, or can be shared among multiple users.

Specifies the Oracle database to connect to. This may be a Net Service Name defined intnsnames.ora.or an Easy Connection Identifier. Either form of connection identifier may be prefixed with username and password information.

[[/]@][//][:]/.

[ [/ ] @]

访问Oracle数据库的用户名和密码。

The name of theOracle工作区Managerworkspace that will be used by the reader. All tables will be read using the same workspace. If this parameter is omitted, or left blank, the default LIVE workspace will be used.

如果选择此参数（默认值），则Oracle数据库连接仍然适用于其他请求者。持久连接对于长期运行的工作空间或使用FME服务器发布。

If this parameter is deselected, the connection to the Oracle database is closed as soon as possible after data processing is complete.

If selected or set to Yes, the Table List (in the reader parameters dialog and in the parameter dialog for Feature Types to Read), and the Merge Filter parameter in the reader feature types dialog will include tables that live in system schemas or which contain special characters like/and$。

If deselected or set to No, the Table List and the Merge Filter will not include system tables or tables with special characters.

Note that recycled tables (names starting with班$）永远不会被包括在内。

Specifies whether to keep the table qualifier. The full name of a table in a database is of the format:

.

Depending on the database format, the字首can be.那， 或者。

选择此参数表示读者应在没有任何前缀的情况下返回表名。例如，当创建将使用相同的表名称传递给另一个组织的工作空间时，这是有用的，或者使用不同的数据库格式，但具有不同的用户名。

在工作区生成期间选择此参数时，源特征类型将是没有任何前缀的表名;否则，它们将包含所有者名称作为前缀。建议您在生成工作区后不会更改此参数，因为没有将功能成功传递给Writer（因为编写器预期具有不同名称的特征类型）。

Note: ">笔记：Even when this parameter is selected, if the table is owned by a user other than the current user, the prefix will not be dropped. This is to ensure that the reader will find the correct table.

控制Oracle Spatial Object Reader是否读取3D多边形作为3D面几何形状或常规多边形。

指定数据库连接后，单击“浏览”按钮以选择导入的表。系统从数据库编译表格时出现一个连接窗口。

Once the table list appears, you can select one or more tables, and then click OK to dismiss the window. The table name(s) will appear in the Table List field in the parameter box.

Enter any SQL在哪里子句，其约束在图层列表中选择的层的属性（例如，Numlanes = 2）。

选中此框允许读者解析MapInfo样式和索引列。

此可选的Generation参数指定MapInfo Symbology Style列的名称。如果找到此名称的列，则将从生成的源特征类型的架构中省略它，并且参数将设置为此列的名称。

This optional generation parameter specifies the name of the MapInfo symbology index column. If a column by this name is found, it will be omitted from the schema of the generated source feature type.

Use this parameter to exposeFormat Attributesin Workbench when you create a workspace:

• 在一个dynamic scenario，这意味着这些属性可以在运行时传递到输出数据集。
• 在非动态方案中，此参数允许您在多个要素类型上公开其他属性。单击“浏览”按钮以查看读者的可用格式属性（对于每种格式不同）。

When selected, this parameter removes any portions of imported features being read that are outside the Search Envelope.

The example below illustrates the results of the Search Envelope when剪辑搜索信封is not selected (set to No) and when it is selected (set to Yes).

• 否：将读取跨越搜索包络边界的任何功能，包括位于边界外部的部分。
• Yes: Any features that cross the search envelope boundary will be clipped at the boundary, and only the portion that lies inside the boundary will be read. The underlying function for the剪辑搜索信封function is an intersection; however, when剪辑搜索信封选择，除了交叉点之外还执行剪辑操作。

如果它与数据的坐标系不同，则指定搜索信封的坐标系。如果设置此参数，必须始终设置与要读取的数据关联的坐标系。

If this parameter is set, the minimum and maximum points of the search envelope are reprojected from the Search Envelope Coordinate System to the reader’s coordinate system prior to applying the envelope.

使用批量读取技术从Oracle数据库读取行以最大化性能。此参数允许您通过指定一次从数据库读取多少行来调整读取器的性能。

默认为200。

This parameter allows for the execution of SQL statements before opening a table for reading. For example, it may be necessary to create a temporary view before attempting to read from it.

有关SQL函数的详细信息，请单击“相应的菜单项”中SQL to Run editor help。

可用的菜单选项取决于格式。

Multiple SQL commands can be delimited by a character specified using theFME_SQL_DELIMITERdirective, embedded at the beginning of the SQL block. The single character following this directive will be used to split the SQL block into SQL statements, which will then be sent to the database for execution.笔记：Include a space before the character.

For example:

FME_SQL_DELIMITER ; DELETE FROM instructors ; DELETE FROM people WHERE LastName='Doe' AND FirstName='John'

Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.

Any errors occurring during the execution of these SQL statements will normally terminate the reader or writer (depending on where the SQL statement is executed) with an error. If the specified statement is preceded by a hyphen (“-”), such errors are ignored.

此参数允许在读取一组表后执行SQL语句。例如，可能需要在创建它之后清理临时视图。

有关SQL函数的详细信息，请单击“相应的菜单项”中SQL to Run editor help。

可用的菜单选项取决于格式。

Multiple SQL commands can be delimited by a character specified using theFME_SQL_DELIMITERdirective, embedded at the beginning of the SQL block. The single character following this directive will be used to split the SQL block into SQL statements, which will then be sent to the database for execution.笔记：Include a space before the character.

For example:

FME_SQL_DELIMITER ; DELETE FROM instructors ; DELETE FROM people WHERE LastName='Doe' AND FirstName='John'

Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.

Any errors occurring during the execution of these SQL statements will normally terminate the reader or writer (depending on where the SQL statement is executed) with an error. If the specified statement is preceded by a hyphen (“-”), such errors are ignored.

If this parameter is set to Yes, feature geometry will be read into an aggregate.

A parameter is set on the aggregate to indicate that each part of the aggregate is independent from the others, and its own geometry. Geometry parts of the aggregate are named and contain geometry according to their respective column in the table being read.

如果几何读取为null，则将其附加到聚合作为空几何。几何特定数据通常添加到该功能的属性将被添加为几何图形。

Note: ">笔记：When using this feature, neither the geometry column, nor the feature type SELECT statement can be specified. Also, tables with topology columns will not be read in this mode.

This parameter specifies the type of relationship which must exist between the search envelope and the geometry in the target layer. Any supported relationship, or combination of relationships, may be specified.

This table lists the valid geometry interaction relationships.

除了指定单个关系之外，还可以通过将它们与加号（+）连接来指定要测试的关系的组合。例如，参数可以指定为内部+触摸。

This specifies the test that is applied to the results of the above geometry relationship comparison. When using the object model, Spatial queries return results of TRUE rather than the name of the interaction – as they do with the older relational model – so the default test for the object model is “= ‘TRUE’”, regardless of the type of interaction involved.