disable all checks

Skip all table existence checks.

USYS$ORA_PARAMS = disable all checks

USYS$ORA_PARAMS = dac

Description

When this option is specified, all existence and checks related to Oracle database objects are skipped. For more information, see Table Existence Checks.

Caution: Use this connector option with extreme care. It is safer to let the connector perform the table existence check.

By default, the table existence check is performed. A table existence check may be considered redundant in a production environment, where tables and procedures are present and should not be created on the fly. However, the check also gathers information for other checks, and these may improve performance for Unicode databases (depending on your Oracle database configuration). Therefore, skipping the table existence checks may improve initial table access and viewing performance, but degrade performance when retrieving data.