1/下载oracle 安装包,并解压到soft下WINDOWS_19c_db_home
2/点击setup.exe开始安装,安装参考https://blog.csdn.net/weixin_44841225/article/details/100782269,注意用管理员英文用户安装,
本机安装在了temp用户下cdb=orcl,pdb=PCOMM
3/安装完成后,cmd打开命令窗口,sqlplus / as sysdba;(或者 sqlplus ,输入 system/123456)
4/切换到pdb,show pdbs;alter session set container=PCOMM;
5/创建表空间create tablespace BTVDEX_DATA datafile 'D:\soft\oradata\BTVDEX_DATA.dbf' size 256M autoextend on;
6/创建用户BTVDEX_DEV ;create user BTVDEX_DEV identified by hgrica1024 default tablespace BTVDEX_DATA;
7/授权 grant sysdba to BTVDEX_DEV ;
grant connect, resource ,dba to BTVDEX_DEV;
alter session set container=PCOMM_CMM;
grant sysdba to BTVDEX_CMM ;
grant connect, resource ,dba to BTVDEX_CMM;
8/创建新的PDB
1/建表空间:create tablespace BTVDEX_CMM_DATA datafile 'D:\soft\oradata\ORCL\PCOMM_CMM\BTVDEX_CMM_DATA.dbf' size 256M autoextend on;<