NOCATALOG

Valid For

DEFGEN

Description

Use NOCATALOG in the DEFGEN parameter file to remove the Oracle AI Database container name from table names before their definitions are written to the definitions file. This parameter is valid if the database supports container names or catalog names and the DEFSFILE parameter includes the FORMAT RELEASE option set to 12.1. Use this parameter if the definitions file is to be used for mapping to a database that only supports two-part names (owner.object).

DEFGEN abends with an error if duplicate schema.table names are encountered once the container or catalog names are removed. This prevents the possibility of processing errors caused by different sets of metadata having the same schema.table name when there is no catalog name to differentiate them.

Default

None

Syntax

NOCATALOG