FORMATXML
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 theSOURCEISFILE
parameter is present. The default is to create oneFORMATXML
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