Oracle GoldenGate 23ai Microservices Architecture REST APIドキュメンテーション

インスタンス化CSNの管理

post

/services/{version}/connections/{connection}/databases/{database}/{schema}/{table}/instantiationCsn

必要なロール: 管理者

フィルタリングのインスタンス化CSNを管理します。

リクエスト

サポートされるメディア・タイプ

application/json

パス・パラメータ

connection(必須): string

最小長: 1

最大長: 61

パターン: ^[a-zA-Z][a-zA-Z0-9_#$]{1,29}([.][a-zA-Z][a-zA-Z0-9_#$]{1,29})?$

接続名。資格証明ストアの別名ごとに、domain.aliasという名前の接続が存在しています。
database(必須): string

最小長: 1

最大長: 130

データベース名。
schema(必須): string

最小長: 1

最大長: 130

データベースのスキーマ名。
table(必須): string

最小長: 1

最大長: 130

データベースの表名。
version(必須): string

Oracle GoldenGateサービスのAPIバージョン。

指定できる値: [ "v2" ]

ルート・スキーマ: Oracle GoldenGate Instantiation CSN

タイトル: Oracle GoldenGate Instantiation CSN

1つに一致

ソースの表示

object Oracle GoldenGate Instantiation CSN-x-oneOf[0]
object Oracle GoldenGate Instantiation CSN-x-oneOf[1]

{
    "x-oneOf":[
        {
            "type":"object",
            "properties":{
                "$schema":{
                    "enum":[
                        "ogg:instantiationCsn"
                    ]
                },
                "command":{
                    "enum":[
                        "clear"
                    ]
                },
                "source":{
                    "description":"Source database name",
                    "type":"string",
                    "minLength":"1",
                    "maxLength":"4096"
                }
            },
            "required":[
                "command",
                "source"
            ],
            "additionalProperties":false
        },
        {
            "type":"object",
            "properties":{
                "$schema":{
                    "enum":[
                        "ogg:instantiationCsn"
                    ]
                },
                "command":{
                    "enum":[
                        "set"
                    ]
                },
                "csn":{
                    "x-oneOf":[
                        {
                            "description":"System Change Number(Normal Format) for Oracle Database.",
                            "type":"integer",
                            "minimum":"0",
                            "maximum":"9223372036854776000",
                            "example":"6488359"
                        },
                        {
                            "description":"System Change Number(Alternate Format) for Oracle Database.",
                            "type":"string",
                            "pattern":"[0-9]+[.][0-9]+",
                            "minLength":"3",
                            "maxLength":"64",
                            "example":"6488359.3456712"
                        }
                    ]
                },
                "source":{
                    "description":"Source database name",
                    "type":"string",
                    "minLength":"1",
                    "maxLength":"4096"
                }
            },
            "required":[
                "command",
                "csn",
                "source"
            ],
            "additionalProperties":false
        }
    ],
    "title":"Oracle GoldenGate Instantiation CSN"
}

ネストされたスキーマ: Oracle GoldenGate Instantiation CSN-x-oneOf[0]

型: object

ソースの表示

$schema:

指定できる値: [ "ogg:instantiationCsn" ]
command(必須):

指定できる値: [ "clear" ]
source(必須): string

最小長: 1

最大長: 4096

ソース・データベース名

{
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:instantiationCsn"
            ]
        },
        "command":{
            "enum":[
                "clear"
            ]
        },
        "source":{
            "description":"Source database name",
            "type":"string",
            "minLength":"1",
            "maxLength":"4096"
        }
    },
    "required":[
        "command",
        "source"
    ],
    "additionalProperties":false
}

ネストされたスキーマ: Oracle GoldenGate Instantiation CSN-x-oneOf[1]

型: object

ソースの表示

$schema:

指定できる値: [ "ogg:instantiationCsn" ]
command(必須):

指定できる値: [ "set" ]
csn(必須): csn
source(必須): string

最小長: 1

最大長: 4096

ソース・データベース名

{
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:instantiationCsn"
            ]
        },
        "command":{
            "enum":[
                "set"
            ]
        },
        "csn":{
            "x-oneOf":[
                {
                    "description":"System Change Number(Normal Format) for Oracle Database.",
                    "type":"integer",
                    "minimum":"0",
                    "maximum":"9223372036854776000",
                    "example":"6488359"
                },
                {
                    "description":"System Change Number(Alternate Format) for Oracle Database.",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":"3",
                    "maxLength":"64",
                    "example":"6488359.3456712"
                }
            ]
        },
        "source":{
            "description":"Source database name",
            "type":"string",
            "minLength":"1",
            "maxLength":"4096"
        }
    },
    "required":[
        "command",
        "csn",
        "source"
    ],
    "additionalProperties":false
}

ネストされたスキーマ: csn

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9223372036854776000

Oracle Databaseの場合のシステム変更番号(標準形式)。

例: 6488359
string

最小長: 3

最大長: 64

パターン: [0-9]+[.][0-9]+

Oracle Databaseの場合のシステム変更番号(代替形式)。

例: 6488359.3456712

{
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":"0",
            "maximum":"9223372036854776000",
            "example":"6488359"
        },
        {
            "description":"System Change Number(Alternate Format) for Oracle Database.",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":"3",
            "maxLength":"64",
            "example":"6488359.3456712"
        }
    ]
}

リクエストの例(application/json)

{
    "command":"set",
    "csn":"32036323",
    "source":"DBNORTH_PDB1"
}

先頭に戻る

レスポンス

サポートされるメディア・タイプ

application/json

201レスポンス

インスタンス化CSNリクエストが正常に完了しました。

ルート・スキーマ: RESTful API Standard Response

型: object

タイトル: RESTful API Standard Response

すべてのOracle GoldenGate RESTful APIコールの標準レスポンス

ソースの表示

$schema:

指定できる値: [ "api:standardResponse" ]
links(必須): array links

最小アイテム数: 0

最大アイテム数: 16

リクエストのOracle GoldenGateリンク
messages(必須): array messages

最小アイテム数: 0

最大アイテム数: 65535

リクエストの間に発行されるGoldenGateメッセージ
response: object response

リクエストのOracle GoldenGateドキュメント

{
    "title":"RESTful API Standard Response",
    "description":"Standard Response for all Oracle GoldenGate RESTful API calls",
    "required":[
        "messages",
        "links"
    ],
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "api:standardResponse"
            ]
        },
        "response":{
            "description":"Oracle GoldenGate document from the request",
            "type":"object"
        },
        "messages":{
            "description":"Oracle GoldenGate messages issued during the request",
            "type":"array",
            "items":{
                "type":"object",
                "properties":{
                    "$schema":{
                        "enum":[
                            "ogg:message"
                        ]
                    },
                    "type":{
                        "description":"An absolute URI [RFC3986] to a page that describes the info, warning or error type.",
                        "type":"string",
                        "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
                        "minLength":"2",
                        "maxLength":"4095"
                    },
                    "title":{
                        "description":"A human-readable description that provides information and detail specific to this occurence of the information, warning or error.",
                        "type":"string",
                        "minLength":"1",
                        "maxLength":"4095"
                    },
                    "code":{
                        "description":"The Oracle GoldenGate message code",
                        "type":"string",
                        "pattern":"^OGG[-][0-9]{5}$",
                        "minLength":"9",
                        "maxLength":"9"
                    },
                    "severity":{
                        "description":"The severity of the message",
                        "enum":[
                            "INFO",
                            "WARNING",
                            "ERROR"
                        ]
                    },
                    "issued":{
                        "description":"The date and time that the message was issued",
                        "type":"string",
                        "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])$",
                        "minLength":"20",
                        "maxLength":"32"
                    }
                },
                "required":[
                    "type",
                    "title",
                    "code",
                    "severity",
                    "issued"
                ],
                "additionalProperties":false
            },
            "minItems":"0",
            "maxItems":"65535"
        },
        "links":{
            "description":"Oracle GoldenGate links for the request",
            "type":"array",
            "items":{
                "type":"object",
                "properties":{
                    "$schema":{
                        "enum":[
                            "ogg:link"
                        ]
                    },
                    "rel":{
                        "description":"Relationship of href to the requested link",
                        "enum":[
                            "alternate",
                            "canonical",
                            "current",
                            "describedby",
                            "describes",
                            "enclosure",
                            "parent",
                            "related",
                            "self",
                            "first",
                            "last",
                            "next",
                            "previous",
                            "ogg://service"
                        ]
                    },
                    "href":{
                        "description":"An absolute URI for the link",
                        "type":"string",
                        "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
                        "minLength":"2",
                        "maxLength":"4095"
                    },
                    "mediaType":{
                        "description":"Media type - see RFC 4288 (https://tools.ietf.org/html/rfc4288)",
                        "type":"string",
                        "pattern":"^(text|application)/[a-zA-Z0-9!#$&.+-^_]+$",
                        "minLength":"6",
                        "maxLength":"255"
                    },
                    "description":{
                        "description":"A human-readable description that provides information and detail specific to this link.",
                        "type":"string",
                        "minLength":"1",
                        "maxLength":"4095"
                    }
                },
                "required":[
                    "rel",
                    "href"
                ],
                "additionalProperties":false
            },
            "minItems":"0",
            "maxItems":"16"
        }
    },
    "additionalProperties":false
}

ネストされたスキーマ: links

型: array

最小アイテム数: 0

最大アイテム数: 16

リクエストのOracle GoldenGateリンク

ソースの表示

配列: object items

{
    "description":"Oracle GoldenGate links for the request",
    "type":"array",
    "items":{
        "type":"object",
        "properties":{
            "$schema":{
                "enum":[
                    "ogg:link"
                ]
            },
            "rel":{
                "description":"Relationship of href to the requested link",
                "enum":[
                    "alternate",
                    "canonical",
                    "current",
                    "describedby",
                    "describes",
                    "enclosure",
                    "parent",
                    "related",
                    "self",
                    "first",
                    "last",
                    "next",
                    "previous",
                    "ogg://service"
                ]
            },
            "href":{
                "description":"An absolute URI for the link",
                "type":"string",
                "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
                "minLength":"2",
                "maxLength":"4095"
            },
            "mediaType":{
                "description":"Media type - see RFC 4288 (https://tools.ietf.org/html/rfc4288)",
                "type":"string",
                "pattern":"^(text|application)/[a-zA-Z0-9!#$&.+-^_]+$",
                "minLength":"6",
                "maxLength":"255"
            },
            "description":{
                "description":"A human-readable description that provides information and detail specific to this link.",
                "type":"string",
                "minLength":"1",
                "maxLength":"4095"
            }
        },
        "required":[
            "rel",
            "href"
        ],
        "additionalProperties":false
    },
    "minItems":"0",
    "maxItems":"16"
}

ネストされたスキーマ: messages

型: array

最小アイテム数: 0

最大アイテム数: 65535

リクエストの間に発行されるGoldenGateメッセージ

ソースの表示

配列: object items

{
    "description":"Oracle GoldenGate messages issued during the request",
    "type":"array",
    "items":{
        "type":"object",
        "properties":{
            "$schema":{
                "enum":[
                    "ogg:message"
                ]
            },
            "type":{
                "description":"An absolute URI [RFC3986] to a page that describes the info, warning or error type.",
                "type":"string",
                "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
                "minLength":"2",
                "maxLength":"4095"
            },
            "title":{
                "description":"A human-readable description that provides information and detail specific to this occurence of the information, warning or error.",
                "type":"string",
                "minLength":"1",
                "maxLength":"4095"
            },
            "code":{
                "description":"The Oracle GoldenGate message code",
                "type":"string",
                "pattern":"^OGG[-][0-9]{5}$",
                "minLength":"9",
                "maxLength":"9"
            },
            "severity":{
                "description":"The severity of the message",
                "enum":[
                    "INFO",
                    "WARNING",
                    "ERROR"
                ]
            },
            "issued":{
                "description":"The date and time that the message was issued",
                "type":"string",
                "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])$",
                "minLength":"20",
                "maxLength":"32"
            }
        },
        "required":[
            "type",
            "title",
            "code",
            "severity",
            "issued"
        ],
        "additionalProperties":false
    },
    "minItems":"0",
    "maxItems":"65535"
}

ネストされたスキーマ: response

型: object

リクエストのOracle GoldenGateドキュメント

ネストされたスキーマ: items

型: object

ソースの表示

$schema:

指定できる値: [ "ogg:link" ]
description: string

最小長: 1

最大長: 4095

このリンク固有の情報と詳細を提供する、人が読むための説明。
href(必須): string

最小長: 2

最大長: 4095

パターン: ^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \t]*$

リンクの絶対URI
mediaType: string

最小長: 6

最大長: 255

パターン: ^(text|application)/[a-zA-Z0-9!#$&.+-^_]+$

メディア・タイプ - RFC 4288 (https://tools.ietf.org/html/rfc4288)を参照
rel(必須):

指定できる値: [ "alternate", "canonical", "current", "describedby", "describes", "enclosure", "parent", "related", "self", "first", "last", "next", "previous", "ogg://service" ]

hrefとリクエスト対象のリンクlinkの関係

{
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:link"
            ]
        },
        "rel":{
            "description":"Relationship of href to the requested link",
            "enum":[
                "alternate",
                "canonical",
                "current",
                "describedby",
                "describes",
                "enclosure",
                "parent",
                "related",
                "self",
                "first",
                "last",
                "next",
                "previous",
                "ogg://service"
            ]
        },
        "href":{
            "description":"An absolute URI for the link",
            "type":"string",
            "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
            "minLength":"2",
            "maxLength":"4095"
        },
        "mediaType":{
            "description":"Media type - see RFC 4288 (https://tools.ietf.org/html/rfc4288)",
            "type":"string",
            "pattern":"^(text|application)/[a-zA-Z0-9!#$&.+-^_]+$",
            "minLength":"6",
            "maxLength":"255"
        },
        "description":{
            "description":"A human-readable description that provides information and detail specific to this link.",
            "type":"string",
            "minLength":"1",
            "maxLength":"4095"
        }
    },
    "required":[
        "rel",
        "href"
    ],
    "additionalProperties":false
}

ネストされたスキーマ: items

型: object

ソースの表示

$schema:

指定できる値: [ "ogg:message" ]
code(必須): string

最小長: 9

最大長: 9

パターン: ^OGG[-][0-9]{5}$

Oracle GoldenGateメッセージ・コード
issued(必須): string

最小長: 20

最大長: 32

パターン: ^[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])$

メッセージが発行された日時
severity(必須):

指定できる値: [ "INFO", "WARNING", "ERROR" ]

メッセージの重大度
title(必須): string

最小長: 1

最大長: 4095

この情報、警告またはエラーに固有の情報と詳細を提供する、人が読むための説明。
type(必須): string

最小長: 2

最大長: 4095

パターン: ^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \t]*$

情報、警告またはエラーのタイプを説明するページの絶対URI [RFC3986]。

{
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:message"
            ]
        },
        "type":{
            "description":"An absolute URI [RFC3986] to a page that describes the info, warning or error type.",
            "type":"string",
            "pattern":"^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \\t]*$",
            "minLength":"2",
            "maxLength":"4095"
        },
        "title":{
            "description":"A human-readable description that provides information and detail specific to this occurence of the information, warning or error.",
            "type":"string",
            "minLength":"1",
            "maxLength":"4095"
        },
        "code":{
            "description":"The Oracle GoldenGate message code",
            "type":"string",
            "pattern":"^OGG[-][0-9]{5}$",
            "minLength":"9",
            "maxLength":"9"
        },
        "severity":{
            "description":"The severity of the message",
            "enum":[
                "INFO",
                "WARNING",
                "ERROR"
            ]
        },
        "issued":{
            "description":"The date and time that the message was issued",
            "type":"string",
            "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])$",
            "minLength":"20",
            "maxLength":"32"
        }
    },
    "required":[
        "type",
        "title",
        "code",
        "severity",
        "issued"
    ],
    "additionalProperties":false
}

レスポンスの例(application/json)

{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/HR/EMPLOYEES/instantiationCsn",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/HR/EMPLOYEES/instantiationCsn",
            "mediaType":"application/json",
            "rel":"self"
        }
    ],
    "messages":[
        {
            "$schema":"ogg:message",
            "code":"OGG-10463",
            "issued":"2024-04-03T22:36:23Z",
            "severity":"INFO",
            "title":"Instantiation CSN has been set successfully.",
            "type":"https://docs.oracle.com/en/middleware/goldengate/core/23.4/error-messages/"
        }
    ]
}

先頭に戻る