首页 > 技术文章 > oracle-创建账户失败

fengwenqian 2019-07-04 17:34 原文

>select * from v$version;                   //查看12c版本

>select sys_context('USERENV','CON_NAME') from dual;         //查看当前使用的容器

>select con_id,dbid,name,open_mode from v$pdbs;  

>alter pluggable database pdboaec open;

>select con_id,dbid,name,open_mode from v$pdbs;  

>alter session set container=pdboaec;      // 切换容器到pdb

>select sys_context('USERENV','CON_NAME') from dual;

>create user sidney identified by out_standing1 default tablespace users quota 10M on users temporary tablespace temp account unlock;


推荐阅读