oracle@san:pdb01:/u01/app/ggs01

> sqlplus hr/hr

SQL*Plus: Release 11.2.0.3.0 Production on Sun Aug 11 17:43:20 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning and Automatic Storage Management options

SAN:(HR@pdb01):PRIMARY> @demo1

SAN:(HR@pdb01):PRIMARY> CREATE TABLE t1 (

  2    id   INT NOT NULL,

  3    name VARCHAR2(30) DEFAULT SYS_CONTEXT ('USERENV', 'DB_NAME') NOT NULL,

  4    CONSTRAINT t1_pk PRIMARY KEY (id)

  5  );

Table created.

SAN:(HR@pdb01):PRIMARY> insert into t1(id) values(1);

1 row created.

SAN:(HR@pdb01):PRIMARY> commit;

Commit complete.

SAN:(HR@pdb01):PRIMARY> select * from t1;

        ID NAME

---------- ------------------------------

         1 pdb01

SAN:(HR@pdb01):PRIMARY> select * from t2;

        ID NAME

---------- ------------------------------

         1 pdb02

SAN:(HR@pdb01):PRIMARY>

oracle@san:pdb02:/u01/app/ggs02

> sqlplus hr/hr

SQL*Plus: Release 11.2.0.3.0 Production on Sun Aug 11 17:43:16 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning and Automatic Storage Management options

SAN:(HR@pdb02):PRIMARY> @demo2

SAN:(HR@pdb02):PRIMARY> CREATE TABLE t2 (

  2    id   INT NOT NULL,

  3    name VARCHAR2(30) DEFAULT SYS_CONTEXT ('USERENV', 'DB_NAME') NOT NULL,

  4    CONSTRAINT t2_pk PRIMARY KEY (id)

  5  );

Table created.

SAN:(HR@pdb02):PRIMARY> insert into t2(id) values(1);

1 row created.

SAN:(HR@pdb02):PRIMARY> commit;

Commit complete.

SAN:(HR@pdb02):PRIMARY> select * from t1;

        ID NAME

---------- ------------------------------

         1 pdb01

SAN:(HR@pdb02):PRIMARY> select * from t2;

        ID NAME

---------- ------------------------------

         1 pdb02

SAN:(HR@pdb02):PRIMARY>