Valid for
Extract
Description
Use the FORMATXML
parameter to output data in XML format, instead of the default Oracle GoldenGate canonical format. A FORMATXML
statement affects all extract files or trails that are defined after it.
Note:
Do not use FORMATXML
if the data will be processed by the Replicat process. Replicat expects the default canonical format. Do not use FORMATXML
if FORMATASCII
or FORMATSQL
is being used.
Default
None
Syntax
FORMATXML [option] [, ...]
option
is one of the following.
INLINEPROPERTIES | NOINLINEPROPERTIES
Controls whether properties are included within the XML tag or written separately. INLINEPROPERTIES
is the default.
ONERECPERTRANS
Causes Extract to create one FORMATXML
transaction per record if the SOURCEISFILE
parameter is present. The default is to create one FORMATXML
transaction per file.
TRANS | NOTRANS
Controls whether transaction boundaries and commit timestamps should be included in the XML output. TRANS
is the default.
Example
FORMATXML NOINLINEPROPERTIES, NOTRANS