-
/*查看当前使用容器*/
-
select sys_context('USERENV','CON_NAME') FROM DUAL;
-
-
/*查看pdb容器状态*/
-
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
-
-
/*打开PDB*/
-
alter pluggable database ORCLPDB open;
-
-
/*切换到PDB*/
-
alter session set container=ORCLPDB;
-
-
/*查看当前使用容器*/
-
select sys_context('USERENV','CON_NAME') FROM DUAL;
-
-
/*===================================================================*/
-
-
/*第1步：创建临时表空间 */
-
create temporary tablespace shop_temp
-
tempfile 'C:appfanvirtualoradataorclorclpdbshop_temp.dbf'
-
size 50m
-
autoextend on
-
next 50m maxsize 20480m
-
extent management local;
-
-
/*第2步：创建数据表空间 */
-
create tablespace shop
-
logging
-
datafile 'C:appfanvirtualoradataorclorclpdbshop.dbf'
-
size 50m
-
autoextend on
-
next 50m maxsize 20480m
-
extent management local;
-
-
/*第3步：创建用户并指定表空间 */
-
create user shop identified by shop
-
default tablespace shop
-
temporary tablespace shop_temp;
-
-
/*第4步：给用户授予权限 */
-
grant connect,resource,dba to shop;
版权说明
文章采用： 《署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)》许可协议授权。版权声明：未标注转载均为本站原创，转载时请以链接形式注明文章出处。如有侵权、不妥之处，请联系站长删除。敬请谅解！
常见资源合集和破解 fmvvvteih...