#打开控制台dos界面,运行sqlplus;
sqlplus
# sys用户登录,输入账号密码
sys/as sysdba;
#展示连接方式:pdb/cdb;
show con_name;
#打开插拔式数据库pdborcl,若无,请打开Database Configuration Assistant 自行创建 ;
alter session set container=pdborcl;
alter pluggable database pdborcl open;
#创建临时表空间
create temporary tablespace pdbadmin_temp tempfile 'D:\software\oracle\pdboradata\pdborcl\pdbadmin_temp01.dbf'
size 32m autoextend on next 32m MAXSIZE unlimited extent management local;
#创建默认表空间
create tablespace pdbadmin_data logging datafile 'D:\software\oracle\pdboradata\pdborcl\pdbadmin_data01.dbf' size 10240m
autoextend on next 100m MAXSIZE unlimited extent management local;
#创建pdbadmin账号
create user pdbadmin identified by 123456 ;
#授权资源、连接权限到pdbadmin
grant connect,resource to pdbadmin;
#添加创建资源权限到pdbadmin
grant create view to pdbadmin;
#修改pdbamdin账号表空间
alter user pdbadmin default tablespace pdbadmin_data temporary tablespace pdbadmin_temp;
#添加pdbadmin账号的系统权限
grant unlimited tablespace to pdbadmin;