1. Oracle GoldenGate Microservices REST API
  2. タスク
  3. Administrative Server
  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:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
            "mediaType":"application/json",
            "rel":"self"
        },
        {
            "href":"http://localhost:11001/services/v2/metadata-catalog/database",
            "mediaType":"application/schema+json",
            "rel":"describedby"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:collection",
        "items":[
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/AUDSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"AUDSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYSTEM",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSTEM"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYSBACKUP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSBACKUP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYSDG",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSDG"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYSKM",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSKM"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYSRAC",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYSRAC"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/OUTLN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OUTLN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/XS%24NULL",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"XS$NULL"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/GSMADMIN_INTERNAL",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMADMIN_INTERNAL"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/GSMUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/DIP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DIP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/REMOTE_SCHEDULER_AGENT",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"REMOTE_SCHEDULER_AGENT"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/DBSFWUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DBSFWUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/ORACLE_OCM",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ORACLE_OCM"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SYS%24UMF",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SYS$UMF"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/DBSNMP",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DBSNMP"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/APPQOSSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"APPQOSSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/GSMCATUSER",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GSMCATUSER"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/GGSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/XDB",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"XDB"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/ANONYMOUS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ANONYMOUS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/WMSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"WMSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/OJVMSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OJVMSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/CTXSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"CTXSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/ORDSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ORDSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/ORDDATA",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ORDDATA"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/ORDPLUGINS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"ORDPLUGINS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SI_INFORMTN_SCHEMA",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SI_INFORMTN_SCHEMA"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/MDSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"MDSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/OLAPSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OLAPSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/MDDATA",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"MDDATA"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/SPATIAL_CSW_ADMIN_USR",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"SPATIAL_CSW_ADMIN_USR"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/DVSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DVSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/LBACSYS",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"LBACSYS"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/DVF",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"DVF"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/GGADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"GGADMIN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/TKGGADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"TKGGADMIN"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/TKGGUSER01",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"TKGGUSER01"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/TKGGUSER02",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"TKGGUSER02"
            },
            {
                "$schema":"ogg:collectionItem",
                "links":[
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL",
                        "mediaType":"application/json",
                        "rel":"parent"
                    },
                    {
                        "href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/databases/ORCL/OGGADMIN",
                        "mediaType":"application/json",
                        "rel":"canonical"
                    }
                ],
                "name":"OGGADMIN"
            }
        ]
    }
}
先頭に戻る