Shulou(Shulou.com)06/01 Report--

Change PDB size

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

2 PDB$SEED READ ONLY NO 3 PDBTEST MOUNTED 4 CLONEPDB_PLUG MOUNTED

SQL> ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED);

ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED)

*

Error in line 1:

ORA-65046: This operation is not allowed from outside pluggable databases

SQL> alter session set container=PDBTEST;

Session has changed.

SQL> ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED);

ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED) *

Error in line 1:

ORA-01219: Database or insertable database not open: queries allowed only in fixed tables or views

SQL> startup Pluggable database is open.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDBTEST READ WRITE NO

SQL> ALTER PLUGGABLE DATABASE STORAGE(MAXSIZE UNLIMITED);

Pluggable database has changed.

SQL> alter session set container=CDB$ROOT;

Session has changed.

SQL> SELECT SYS_CONTEXT ('USERENV', 'CON_NAME') FROM DUAL;

SYS_CONTEXT('USERENV','CON_NAME')

CDB$ROOT

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 PDBTEST READ WRITE NO 4 CLONEPDB_PLUG MOUNTED

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.