oracle 19c pdb账号创建

#打开控制台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;