时间:2021-07-01 10:21:17 帮助过:34人阅读
col pdb_name for a30
命令
sqlplus sys/dwh as sysdba;
select name,cdb from v$database;
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;
CON_ID DBID NAME OPEN_MODE ---------- ---------- ------------------------------ ---------- 2 964253477 PDB$SEED READ ONLY 3 3329151580 ORCLPDB MOUNTED
SQL> create user c##test identified by test; SQL> alter session set container=PDBORCL; 会话已更改。 SQL> show con_name; CON_NAME ------------------------------ PDBORCL
SQL> startup; 插接式数据库已打开。 SQL> create user test identified by test default tablespace users temporary tablespace temp; 用户已创建。 SQL> grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to test ; 授权成功。 SQL>
D:\java\Orcal_database\Orcal\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora文件中添加
ORCLPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLPDB) ) )
Oracle12C用户创建、授权、登录
标签:sysdba min star space oracle12c session containe images ide