Jump to

• Request
• Response

The snapshots of all pluggable databases (PDBs) in the Container Database

get

/database/pdb_snapshots/

Returns records from dba_pdb_snapshots. A client requires SQL Administrator role to invoke this service.

Request

Query Parameters

• limit: integer(int32)
  The maximum number of records to return.
• q:
  Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.

  Examples

  Select an example FilterCriteriaExample OrderByPropertyExample FilterAndOrderExample

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

PDB snapshots in the container database.

Body ()

Root Schema : DatabasePluggableSnapshots

Type: object

Show Source

• count: integer
  Total number of records in the current response.
• hasMore: boolean
  Indicates if there are more records to be retrieved.
• items: array items
• limit: integer
  The actual page size limit on number of records applied by the server.
• links: array links
• offset: integer
  The actual index from which the item resources are returned.

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/DatabasePluggableSnapshotItem"
            }
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates if there are more records to be retrieved."
        },
        "limit":{
            "type":"integer",
            "description":"The actual page size limit on number of records applied by the server."
        },
        "offset":{
            "type":"integer",
            "description":"The actual index from which the item resources are returned."
        },
        "count":{
            "type":"integer",
            "description":"Total number of records in the current response."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object DatabasePluggableSnapshotItem
  This object describes Pluggable Database Snapshots associated with the current instance.

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/DatabasePluggableSnapshotItem"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : DatabasePluggableSnapshotItem

Type: object

This object describes Pluggable Database Snapshots associated with the current instance.

Show Source

• con_id: integer
  The ID of the container to which the data pertains.
• con_name: string
  Name of the PDB.
• con_uid: integer
  Unique identifier associated with the PDB.
• full_snapshot_path: string
  Full path for the snapshot.
• links: array links
• previous_snapshot_scn: integer
  SCN at which the previous snapshot for the PDB was taken
• previous_snapshot_time: integer
  Timestamp of the previous snapshot for this PDB.
• snapshot_name: string
  Snapshot name of the PDB.
• snapshot_scn: integer
  SCN at which the snapshot was taken.
• snapshot_time: integer
  Timestamp at which the snapshot was taken.

{
    "type":"object",
    "description":"This object describes Pluggable Database Snapshots associated with the current instance.",
    "properties":{
        "con_id":{
            "type":"integer",
            "description":"The ID of the container to which the data pertains."
        },
        "con_uid":{
            "type":"integer",
            "description":"Unique identifier associated with the PDB."
        },
        "con_name":{
            "type":"string",
            "description":"Name of the PDB."
        },
        "snapshot_name":{
            "type":"string",
            "description":"Snapshot name of the PDB."
        },
        "snapshot_scn":{
            "type":"integer",
            "description":"SCN at which the snapshot was taken."
        },
        "previous_snapshot_scn":{
            "type":"integer",
            "description":"SCN at which the previous snapshot for the PDB was taken"
        },
        "snapshot_time":{
            "type":"integer",
            "description":"Timestamp at which the snapshot was taken."
        },
        "previous_snapshot_time":{
            "type":"integer",
            "description":"Timestamp of the previous snapshot for this PDB."
        },
        "full_snapshot_path":{
            "type":"string",
            "description":"Full path for the snapshot."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Show Source

• href(required): string
• rel(required): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}

Back to Top