How to set and check the max size of PLUGGABLE DATABASE STORAGE (Doc ID 2166477.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Goal

You can specify the maximum size for any PDB database using STORAGE clause in CREATE PLUGGABLE DATABASE command. If we need to modify this then we can Use the ALTER PLUGGABLE DATABASE statement to modify a pluggable database (PDB). You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment. The exception is modifying PDB storage limits, for which you must use the pdb_storage_clause of ALTER PLUGGABLE DATABASE.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms