RE: PDBs and oracle parameter

From: Amihay Gonen <>
Date: Mon, 23 Sep 2013 12:07:03 +0000
Message-ID: <>

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: [] On Behalf Of Amihay Gonen Sent: Monday, September 23, 2013 2:56 PM To:
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 ) ?

Amihay Gonen
Oracle Domain Export


-- Received on Mon Sep 23 2013 - 14:07:03 CEST

Original text of this message