- /*查看当前使用容器*/
- 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)》许可协议授权。版权声明：未标注转载均为本站原创，转载时请以链接形式注明文章出处。如有侵权、不妥之处，请联系站长删除。敬请谅解！
常见资源合集和破解beqptwpmc...