DELETE TRANDATA - Oracle Help Center

Trang chủ » Xoa Gg » DELETE TRANDATA - Oracle Help Center

Có thể bạn quan tâm

Home / Middleware / Oracle GoldenGate for Windows and UNIX DELETE TRANDATA

Use DELETE TRANDATA to do one of the following:

  • DB2 LUW and DB2 on z/OS: Alters the table to DATA CAPTURE NONE.

  • Oracle: Disable supplemental logging.

  • Sybase: Disable replication.

  • SQL Server: Stop extended logging.

By default, this command attempts to remove the supplemental logging of the key columns that are used by Oracle GoldenGate (can be the primary key, a unique key, KEYCOLS columns, or all columns) and also the scheduling columns. The scheduling columns are the primary key, all of the unique keys, and all of the foreign keys. To delete the logging of the Oracle GoldenGate key columns, but not the scheduling columns, include the NOSCHEDULINGCOLS option with DELETE TRANDATA. If ADD TRANDATA was issued with the ALLCOLS option, use DELETE TRANDATA with the ALLCOLS option to remove the supplemental logging of all of the columns, including the Oracle GoldenGate key columns.

Use the DBLOGIN command to establish a database connection before using this command. The user specified with this command must have the same privileges that are required for ADD TRANDATA.

Syntax

DELETE TRANDATA [container.]owner.table [NOSCHEDULINGCOLS | ALLCOLS] [container.]owner.table

The pluggable database (if this is an Oracle multitentant container database), owner and name of the table or file. A wildcard can be used for any name component.

NOSCHEDULINGCOLS

Prevents the command from removing the supplemental logging of the scheduling columns of the specified table. The scheduling columns are the primary key, all of the unique keys, and all of the foreign keys of a table.

ALLCOLS

Removes the supplemental logging of all of the columns of the specified table.

Examples

Example 1 DELETE TRANDATA finance.acct Example 2 DELETE TRANDATA finance.ac* Example 3 DELETE TRANDATA finance.acct ALLCOLS

Từ khóa » Xoa Gg