oracleDropColumnStrategy Section

Normally when a column is removed from the schema it is dropped from the database table it belonged to. On Oracle when the database table is very large dropping a column is a slow operation. This setting allows Oracle users to choose an alternative strategy SET UNUSED.

When this optional setting is set to unused rather then dropping the column from the database table the column will be set as unused. Later the physical columns can be removed with a SQL operation.

Parameter Name

Required

Default

Description

oracleDropColumnStrategy

No

drop

Valid values are:

drop - A DROP COLUMN directive is issued when dropping database columns.

unused - A SET UNUSED directive is issued when dropping database columns.

See Also

.SchemaEditor files

database Section

inputFilePath Section

exportFilePath Section

reportFilePath Section

storageLocations Section

ignoreViews Section

Next

storageLocations Section

oracleDropColumnStrategy Section