RE: PDBs and oracle parameter
- From: Amihay Gonen <Amihay.Gonen@xxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Sep 2013 12:07:03 +0000
I think the documentation in this case is misleading, when trying to do the
operation I got :
SQL> alter session set container=pdb1;
SQL> alter system set log_archive_dest='/tmp' container=current;
alter system set log_archive_dest='/tmp' container=current
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Amihay Gonen
Sent: Monday, September 23, 2013 2:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: PDBs and oracle parameter
I've just going over the parameters which can be changed at PDB level (select *
From parameter where ispdb_modifiable='TRUE';)
ISPDB_MODIFIABLE
VARCHAR2(5)
Indicates whether the parameter can be modified inside a PDB (TRUE) or not
(FALSE).
In a non-CDB, the value of this column is NULL.
I wonder if this field means the every PDB can have different value, or I can
change it from PDB but it affects the complete instance.
For example "log_archive_dest_1" is part of the list , but it don't make sense
to different values (since the redo files are part of the instance level ) ?
Regards,
Amihay Gonen
Oracle Domain Export
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
