dba-tech

Acciones sobre un Pluggable Database:

Que no se puede hacer:

1-
SYS@PDB1> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
2-
SYS@PDB1> alter system set pga_aggregate_target=470m scope=spfile;
alter system set pga_aggregate_target=470m scope=spfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

Que operaciones que  Si se pueden hacer

1-
SYS@PDB1> alter database datafile '/u09/app/oradata/ORCL12/datafile/PDB/pdb_index01.dbf' resize 2m;

Database altered.

Elapsed: 00:00:00.18

Siempre y cuando el tablespace en creado en PDB


2.SYS@PDB1> shutdown immediate
Pluggable Database closed.

3-SYS@PDB1> startup
Pluggable Database opened.