pluggable_databases

Creates, updates, deletes, gets or lists a pluggable_databases resource.

Overview

Name	pluggable_databases
Type	Resource
Id	google.oracledatabase.pluggable_databases

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The name of the PluggableDatabase resource in the following format: projects/{project}/locations/{region}/pluggableDatabases/{pluggable_database}
createTime	string (google-datetime)	Output only. The date and time that the PluggableDatabase was created.
ociUrl	string	Output only. HTTPS link to OCI resources exposed to Customer via UI Interface.
properties	object	Optional. The properties of the PluggableDatabase. (id: PluggableDatabaseProperties)

list

Name	Datatype	Description
name	string	Identifier. The name of the PluggableDatabase resource in the following format: projects/{project}/locations/{region}/pluggableDatabases/{pluggable_database}
createTime	string (google-datetime)	Output only. The date and time that the PluggableDatabase was created.
ociUrl	string	Output only. HTTPS link to OCI resources exposed to Customer via UI Interface.
properties	object	Optional. The properties of the PluggableDatabase. (id: PluggableDatabaseProperties)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, pluggableDatabasesId		Gets details of a single PluggableDatabase.
list	select	projectsId, locationsId	filter, pageSize, pageToken	Lists all the PluggableDatabases for the given project, location and Container Database.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
locationsId	string
pluggableDatabasesId	string
projectsId	string
filter	string
pageSize	integer (int32)
pageToken	string

SELECT examples

get

Gets details of a single PluggableDatabase.

SELECT
name,
createTime,
ociUrl,
properties
FROM google.oracledatabase.pluggable_databases
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pluggableDatabasesId = '{{ pluggableDatabasesId }}' -- required
;

list

Lists all the PluggableDatabases for the given project, location and Container Database.

SELECT
name,
createTime,
ociUrl,
properties
FROM google.oracledatabase.pluggable_databases
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;