sys@ORCL 16:12:31> show pdbs;

sys@ORCL 16:12:35> alter session set container=TESTDB;

Session altered.

Elapsed: 00:00:00.00
sys@ORCL 16:12:51> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TESTDB.xxxxxx.COM

Elapsed: 00:00:00.01
sys@ORCL 16:13:13> shutdown immediate;
Pluggable Database closed.
sys@ORCL 16:13:30> startup restrict;
Pluggable Database opened.
sys@ORCL 16:13:44> alter pluggable database TESTDB NOLOGGING;

Pluggable database altered.

Elapsed: 00:00:00.03
sys@ORCL 16:14:43> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 TESTDB                       READ WRITE YES


Elapsed: 00:00:00.00
sys@ORCL 16:15:19> update global_name set global_name ='TESTDB';

1 row updated.

Elapsed: 00:00:00.00
sys@ORCL 16:17:28> commit;

Commit complete.

Elapsed: 00:00:00.00
sys@ORCL 16:17:32> select GLOBAL_NAME from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TESTDB


sys@ORCL 16:17:32> alter system set db_domain='' scope=spfile;

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle