Retrieve Extract
get
/services/{version}/extracts/{extract}
Retrieve the details of an extract process.
Request
Path Parameters
-
extract: string
Minimum Length:
1
Maximum Length:8
Pattern:^[A-Z_$][A-Z0-9_$]*$
The name of the extract. Extract names are upper case, begin with an alphabetic character followed by up to seven alpha-numeric characters.
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
The details of the extract were retrieved successfully.
Root Schema : Oracle GoldenGate Extract
Type:
object
Title:
Show Source
Oracle GoldenGate Extract
-
$schema:
Allowed Values:
[ "ogg:extract" ]
-
alias:
object alias
-
begin:
begin
Starting point for data processing
-
config:
array config
Minimum Number of Items:
0
Maximum Number of Items:32767
-
credentials:
credentials
Credentials for source database
-
description:
string
Minimum Length:
1
Maximum Length:4095
Description for the process -
intent:
Default Value:
Unidirectional
Allowed Values:[ "High Availability", "Disaster Recovery", "Unidirectional", "N-Way", "Sharding" ]
Intent for data capture workflow -
miningCredentials:
miningCredentials
Credentials for downstream mining database
-
passive:
boolean
Default Value:
false
Passive extract controlled by an alias on the target -
registration:
registration
Registration with the source database
-
rollover:
Allowed Values:
[ true ]
Causes Extract to increment to the next file in the trail sequence when restarting. -
source:
source
Source of data to process
-
status:
Default Value:
stopped
Allowed Values:[ "starting", "running", "stopped", "killed", "abended" ]
Oracle GoldenGate Process Status -
targets:
array targets
Minimum Number of Items:
0
Maximum Number of Items:1024
Targets for captured data
Nested Schema : alias
Type:
Show Source
object
-
manager:
object manager
Manager server to use
-
name:
string
Minimum Length:
1
Maximum Length:8
Pattern:^[A-Z_$][A-Z0-9_$]*$
Name of passive extract on the source -
proxy:
object proxy
Nested Schema : begin
Starting point for data processing
Default Value:
now
Match One
Show Source
-
Allowed Values:
[ "now" ]
-
string
Minimum Length:
20
Maximum Length:32
Pattern:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
object begin-x-oneOf[2]
Nested Schema : config
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
32767
-
[0]:
string
Minimum Length:
0
Maximum Length:4095
Nested Schema : credentials
Credentials for source database
Default Value:
oracle.doceng.json.BetterJsonNull@506328aa
Match One
Show Source
Nested Schema : miningCredentials
Credentials for downstream mining database
Default Value:
oracle.doceng.json.BetterJsonNull@53a517e9
Match One
Show Source
Nested Schema : registration
Registration with the source database
Default Value:
none
Match One
Show Source
-
registration-x-oneOf[0]
-
Allowed Values:
[ "none", "default" ]
Nested Schema : source
Source of data to process
Match One
Show Source
-
Allowed Values:
[ "tables" ]
Use tables (initial load) -
source-x-oneOf[1]
Nested Schema : targets
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
1024
Targets for captured data
Show Source
Nested Schema : manager
Type:
object
Manager server to use
Show Source
-
host:
host
Host name or IP Address
-
port:
integer
Minimum Value:
1
Maximum Value:65535
IP Port number
Nested Schema : proxy
Type:
Show Source
object
-
credentials:
credentials
Proxy server credentials
-
host:
host
Proxy server host name or IP address
-
port:
integer
Minimum Value:
1
Maximum Value:65535
Proxy server port number
Nested Schema : host
Host name or IP Address
Match One
Show Source
-
string
Minimum Length:
1
Maximum Length:4095
Pattern:^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
Network host name -
string
Minimum Length:
7
Maximum Length:15
Pattern:^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
Network IPv4 address -
string
Minimum Length:
1
Maximum Length:256
Pattern:^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
Network IPv6 address
Nested Schema : credentials
Proxy server credentials
Default Value:
oracle.doceng.json.BetterJsonNull@2e66541a
Match One
Show Source
Nested Schema : host
Proxy server host name or IP address
Match One
Show Source
-
string
Minimum Length:
1
Maximum Length:4095
Pattern:^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
Network host name -
string
Minimum Length:
7
Maximum Length:15
Pattern:^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
Network IPv4 address -
string
Minimum Length:
1
Maximum Length:256
Pattern:^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
Network IPv6 address
Nested Schema : credentials-x-oneOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "ogg:credentialsRef" ]
-
alias:
string
Minimum Length:
1
Maximum Length:30
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
-
domain:
string
Minimum Length:
1
Maximum Length:30
Default Value:OracleGoldenGate
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : at
Match One
Show Source
-
object at-x-oneOf[0]
Position in archive logs (classic mode, non-threaded)
-
object at-x-oneOf[1]
Position in archive logs (classic mode, threaded)
-
object at-x-oneOf[2]
Position at a specific SCN (integrated mode)
Nested Schema : at-x-oneOf[0]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
Match Any
Show Source
Nested Schema : at-x-oneOf[1]
Type:
object
Position in archive logs (classic mode, threaded)
Show Source
-
positions:
array positions
Minimum Number of Items:
1
Maximum Number of Items:100
Nested Schema : positions
Type:
array
Minimum Number of Items:
1
Maximum Number of Items:
Show Source
100
-
[0]:
object items
Position in archive logs for one thread in a classic extract
Nested Schema : items
Type:
object
Position in archive logs for one thread in a classic extract
Show Source
-
position:
position
-
thread:
integer
Minimum Value:
1
Maximum Value:100
Nested Schema : position
Match One
Show Source
-
Allowed Values:
[ "now" ]
-
position-x-oneOf[1]
-
string
Minimum Length:
20
Maximum Length:32
Pattern:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
object position-x-oneOf[3]
Position in archive logs (classic mode, non-threaded)
Nested Schema : position-x-oneOf[3]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
Match Any
Show Source
Nested Schema : credentials-x-oneOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "ogg:credentialsRef" ]
-
alias:
string
Minimum Length:
1
Maximum Length:30
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
-
domain:
string
Minimum Length:
1
Maximum Length:30
Default Value:OracleGoldenGate
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : miningCredentials-x-oneOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "ogg:credentialsRef" ]
-
alias:
string
Minimum Length:
1
Maximum Length:30
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
-
domain:
string
Minimum Length:
1
Maximum Length:30
Default Value:OracleGoldenGate
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : registration-x-oneOf[0]
Match One
Show Source
-
object registration-x-oneOf[0]-x-oneOf[0]
Classic mode registration options
-
object registration-x-oneOf[0]-x-oneOf[1]
Integrated extract registration options
Nested Schema : registration-x-oneOf[0]-x-oneOf[0]
Type:
object
Classic mode registration options
Show Source
-
logretention:
Allowed Values:
[ true ]
Nested Schema : registration-x-oneOf[0]-x-oneOf[1]
Type:
object
Integrated extract registration options
Show Source
-
containers:
array containers
Minimum Number of Items:
0
Maximum Number of Items:256
-
csn:
csn
-
optimized:
boolean
Default Value:
false
-
replace:
boolean
Default Value:
false
If true, replace existing registration details from an extract with the same name - share: share
Match Any
Show Source
Nested Schema : containers
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
256
Nested Schema : items
Match One
Show Source
-
string
Minimum Length:
1
Maximum Length:130
Pattern:^([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : source-x-oneOf[1]
Match One
Show Source
-
object source-x-oneOf[1]-x-oneOf[0]
Use transaction logs with an integrated Extract
-
object source-x-oneOf[1]-x-oneOf[1]
Use transaction logs with classic Extract
Nested Schema : source-x-oneOf[1]-x-oneOf[0]
Type:
object
Use transaction logs with an integrated Extract
Show Source
-
tranlogs:
Allowed Values:
[ "integrated" ]
Nested Schema : source-x-oneOf[1]-x-oneOf[1]
Type:
object
Use transaction logs with classic Extract
Show Source
-
threads:
integer
Minimum Value:
1
Maximum Value:34
-
tranlogs:
Allowed Values:
[ "classic" ]
Nested Schema : items-x-oneOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "ogg:trail" ]
-
name:
string
Minimum Length:
1
Maximum Length:2
Pattern:^[A-Za-z][A-Za-z0-9]?$
The name of the trail -
offset:
integer
Minimum Value:
0
Maximum Value:2147483647
Offset in trail sequence file -
path:
string
Minimum Length:
1
Maximum Length:255
The path where trail data is stored -
remote:
boolean
Default Value:
false
Indicates if trail is local or remote -
sequence:
integer
Minimum Value:
0
Maximum Value:999999999
Default Value:0
Trail beginning sequence number -
sequenceLength:
Default Value:
9
Allowed Values:[ 6, 9 ]
Number of digits in sequence file name -
sequenceLengthFlip:
boolean
Default Value:
false
Indicates sequence number length will change -
sizeMB:
integer
Minimum Value:
1
Maximum Value:2000
Default Value:500
The maximum size, in megabytes, of a file in the trail.
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/extracts/EXT2",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/extracts/EXT2",
"mediaType":"application/json",
"rel":"self"
},
{
"href":"http://localhost:11001/services/v2/metadata-catalog/extract",
"mediaType":"application/schema+json",
"rel":"describedby"
}
],
"messages":[
],
"response":{
"$schema":"ogg:extract",
"begin":"now",
"config":[
"Extract EXT2",
"ExtTrail X2 Format Release 12.3",
"UseridAlias oggadmin",
"Table oggadmin.*;"
],
"credentials":{
"alias":"oggadmin"
},
"registration":{
"csn":1526609
},
"source":{
"tranlogs":"integrated"
},
"status":"running",
"targets":[
{
"name":"X2",
"offset":3987,
"remote":false,
"sequence":0,
"sequenceLength":9,
"sequenceLengthFlip":false,
"sizeMB":500
}
]
}
}