DBLOGIN
Login DB.
Syntax
DBLOGIN
{SOURCEDB dsn |
USERID user[, PASSWORD password] [SYSDBA] |
SOURCEDB dsn, USERID user[, PASSWORD password][SQLID sqlid]
dsn: ODBC datasource name.
Examples
DBLOGIN USERID system, PASSWORD orcl dblogin userid system, password orcl sysdba
ENCRYPT PASSWORD
Generate encrypted password.
Syntax
ENCRYPT PASSWORD password [ENCRYPTKEY keyname] keyname: logical name of an encryption key contained in the ENCKEYS lookup file.
Examples
GGSCI 29> ENCRYPT PASSWORD password No key specified, using default key... Encrypted password: AACAAAAAAAAAAAIAADHGBAYFMJHITAZF
LIST TABLES
List db tables matching searching criteria.
Syntax
LIST TABLES table
Examples
GGSCI 32> dblogin userid gg_test_src, password password Successfully logged into database. GGSCI 33> list tables cust* GG_TEST_SRC.CUSTOMERS Found 1 tables matching list criteria.
ADD TRANDATA
Enable GoldenGate to acquire the transaction information it needs from the transaction logs. Use the DBLOGIN command to establish a database connection before using this command.
Syntax
ADD TRANDATA owner.table [, COLS (column list)] [, INCLUDELONG | EXCLUDELONG] [, LOBSNEVER | LOBSALWAYS | LOBSIFCHANGED] [, NOKEY] [, OLDFORMAT] [, USETRIGGER] owner.table: The owner and table to log transaction data. Table name can be wildcard (*). COLS (column list): For Oracle 9i and later. Adds specific non-key column(s) to supplemental logging. Separate multiple columns with comma, e.g. NAME, ID, DOB. NOKEY: For Oracle 9i and later. Suppresses the supplemental logging of primary key columns. USETRIGGER: For Oracle 9i and later. Forces an update trigger to be installed instead of enabling supplemental logging.
Examples
GGSCI > dblogin userid system, password orcl Successfully logged into database. GGSCI > add trandata gg_test_src.customers Logging of supplemental redo data enabled for table GG_TEST_SRC.CUSTOMERS.
DELETE TRANDATA
Delete update triggers (before Oracle 9i) or disable supplemental logging (Oracle 9i or later).
Syntax
DELETE TRANDATA[, OLDFORMAT] [, USETRIGGER]
Examples
GGSCI > delete trandata gg_test_src.customers Logging of supplemental redo log data disabled for table GG_TEST_SRC.CUSTOMERS.
INFO TRANDATA
Get TRANDATA info.
Syntax
INFO TRANDATA[, OLDFORMAT] [, USETRIGGER]
Examples
GGSCI 7> info trandata gg_test_src.customers Logging of supplemental redo log data is enabled for table GG_TEST_SRC.CUSTOMERS