Purpose

Determines whether the driver returns items that are in the Oracle Recycle Bin for the getTables(), getColumns(), and getTablePrivileges() methods. For Oracle 10g R1 and higher, when a table is dropped, it is not actually removed from the database, but is placed in the recycle bin. By default, the driver returns items in the Oracle Recycle Bin.

Valid Values

true | false

Behavior

If set to true, the driver fetches items contained in the Oracle Recycle Bin.

If set to false, the driver does not return items contained in the Oracle Recycle Bin. Functionally, this means that the driver filters out results whose table name begins with BIN$.

Default

true

Data Type

boolean