8.21 GET_DATABASE_METADATA

Valid For

Extract and Replicat

Description

Use the GET_DATABASE_METADATA function to return the metadata of the database that is associated with a record.

Buffer

typedef struct
{
char*    dbName;
long      dbName_max_length;
long      dbName_actual_length;
unsigned char    dbNameMetadata[MAXDBOBJTYPE];
char*   locale;
long     locale_max_length;
long     locale_actual_length;
} database_def;
typedef struct
{
    database_def  source_db_def;
    database_def  target_db_def;
} database_defs;

Input

dbname

A pointer to a buffer to accept the database name.

dbname_max_length

The maximum length of the buffer to hold the name.

dbname_actual_length

The actual length of the database name.

dbNameMetadata

The name metadata for case-sensitivity, which is the same value that is written by Extract and the data pump to a trail. See Administering Oracle GoldenGate for a list of macros that can be used by the user exit to check database object name metadata, given an object name type.

locale

A null-terminated character string specifying the locale of the database. This is returned as a conjunction of:

  • ISO-639 two-letter language code

  • ISO-3166 two-letter country code

  • Variant code using '_' U+005F as separator.

Example: "en_US", "ja_Japen"

locale_max_length

The maximum length of the buffer to accept the locale.

locale_actual_length

The actual length of the locale.

database_def source_db_def

Directs the process to return metadata for the source database.

database_def target_db_def

Directs the process to return metadata for the target database.