1. Oracle GoldenGate 23ai Microservices Architecture REST APIドキュメンテーション
  2. タスク
  3. 管理サービス
  4. データベース

データベース・スキーマの取得

get

/services/{version}/connections/{connection}/databases/{database}

必要なロール: ユーザー

データベース内のスキーマの名前を取得します。

リクエスト

パス・パラメータ
  • 最小長: 1
    最大長: 61
    パターン: ^[a-zA-Z][a-zA-Z0-9_#$]{1,29}([.][a-zA-Z][a-zA-Z0-9_#$]{1,29})?$

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

  • 最小長: 1
    最大長: 130

    データベース名。

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

    指定できる値: [ "v2" ]
問合せパラメータ

  • スキーマ名フィルタ。ワイルドカード文字'*'または'?'を含みます。

先頭に戻る

レスポンス

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

200レスポンス

スキーマ名が正常に取得されました。

本文()
ルート・スキーマ: Oracle GoldenGate Collection
型: object
タイトル: Oracle GoldenGate Collection
ソースの表示
ネストされたスキーマ: items
型: array
最小アイテム数: 0
最大アイテム数: 32767
ソースの表示
ネストされたスキーマ: items
型: object
使用可能な追加プロパティ: true
ソースの表示
  • 最小長: 1
    最大長: 255
    デフォルト値: ogg:collectionItem
    コレクション・アイテムのスキーマ名。デフォルトはこのスキーマです
  • links
  • 最小長: 1
    最大長: 255
    アイテム名
  • status
    アイテムのステータス
ネストされたスキーマ: status
アイテムのステータス
いずれかに一致
ソースの表示
  • 指定できる値: [ "starting", "running", "stopped", "killed", "abended" ]
  • デフォルト値: stopped
    指定できる値: [ "paused", "running", "stopping", "stopped", "killed", "uninitialized" ]
レスポンスの例(application/json)
{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
            "mediaType":"application/json",
            "rel":"self"
        },
        {
            "href":"http://localhost:9012/services/v2/metadata-catalog/database",
            "mediaType":"application/schema+json",
            "rel":"describedby"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:collection",
        "items":[
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/AUDSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"AUDSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYSTEM",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSTEM"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYSBACKUP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSBACKUP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYSDG",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSDG"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYSKM",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSKM"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYSRAC",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSRAC"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/OUTLN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OUTLN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GSMADMIN_INTERNAL",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMADMIN_INTERNAL"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GSMUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DIP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DIP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/SYS%24UMF",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYS$UMF"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/XS%24NULL",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"XS$NULL"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/REMOTE_SCHEDULER_AGENT",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"REMOTE_SCHEDULER_AGENT"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DBSFWUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DBSFWUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GGSHAREDCAP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGSHAREDCAP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/APPQOSSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"APPQOSSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DGPDB_INT",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DGPDB_INT"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DBSNMP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DBSNMP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GSMCATUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMCATUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GGSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/CTXSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"CTXSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/XDB",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"XDB"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/ANONYMOUS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ANONYMOUS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/WMSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"WMSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/OJVMSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OJVMSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DVSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DVSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/OLAPSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OLAPSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/MDSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"MDSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/MDDATA",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"MDDATA"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/LBACSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"LBACSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/DVF",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DVF"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/PDBADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"PDBADMIN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GGADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGADMIN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/C%23%23GGADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"C##GGADMIN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GGUSER01",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGUSER01"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/GGUSER02",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGUSER02"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:9012/services/v2/connections/OracleGoldenGate.ggsouth/databases/DBNORTH_PDB1/HR",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"HR"
            }
        ]
    }
}
先頭に戻る