Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

Which command forces a running Extract to close the current trial and start writing to the
next trial sequence number?

Which command forces a running Extract to close the current trial and start writing to the
next trial sequence number?

A.
ALTER EXTTRAIL <trail name>, NEXTSEQNO

B.
ALTER EXTTRAIL <trail name>, ROLLOVER

C.
SEND EXTRACT <group>, ETROLLOVER

D.
SEND EXTRACT <group>, ROLLOVER

Explanation:

In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR
{CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID>
[THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER
|SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>]
[TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS |STOP
|TLTRACE {DEBUG | OFF | <level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2]
<tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS
{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS}
|TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |VAMMESSAGE “<Teradata
command>” |VAMMESSAGE {“ARSTATS” | “INCLUDELIST [filter]” | “EXCLUDELIST [filter]”}

|VAMMESSAGE “OPENTRANS”}



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Gautam

Gautam

C – see page 127 of Oracle GoldenGate Windows and UNIX Reference Guide

franciscotmjr

franciscotmjr

Hi Gautam,

The parameter ETROLLOVER exists only for ALTER EXTRACT command. It’s not a valid option for SEND EXTRACT (page 26 of Oracle Goldengate Windows and UNIX Reference Guide, you may check for either 10.4 or 11.1)

S De

S De

And: D

Explanation with sample command: SEND EXTRACT , {
BR {BRINTERVAL |
BRSTART |
BRSTOP |
BRCHECKPOINT {IMMEDIATE | IN {H|M} | AT YYYY-MM-DD HH:MM[:SS]}} |
CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |
ROLLOVER )

AMIRA

AMIRA

Answer is D since ETROLLOVER is used only with ALTER Extract