oracle 12c£ºoracle 12cÔõô´´½¨Óû§

oracle 12c Ôõô´´½¨Óû§

--È·Èϵ±Ç°cdb

SQL> select name,cdb from v$database;

NAME CDB

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

ORCL YES

--²éѯµ±Ç°pdb»ù±¾ÐÅÏ¢

col pdb_name for a30

select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;

select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

´´½¨Ê¹ÓÃÕß

SQL> create user c##test identified by test;

SQL> alter session set container=pdb1;

SQL> show con_name;

SQL> show con_name;

CON_NAME

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

PDBORCL

´´½¨ÕæÕýµÄÓû§

SQL> create user test identified by test default tablespace users temporary tablespace temp;

ÊÚȨ

grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to test