MODIFYING PDB SETTINGS

MODIFYING PDB SETTINGS

SQL> CONNECT AS SYS@PDB1 AS SYSDBA

SQL> ALTER PLUGGABLE DATABASE DATAFILE '+DATA01/PDB1/DATAFILE/PDB1_test01.dbf' ONLINE;

SQL> ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE PDB1_TBS;

SQL> ALTER PLUGGABLE DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01;SQL> ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 2G);

SQL> ALTER PLUGGABLE DATABASE RENAME GLOBAL_NAME TO pdb1_app1;