学习Oracle遇到使用*.sql文档数据通过pdb来读取制作模拟数据的学习环境
1.虚拟机为Linux系统,sqlplus / as sysdba 登录
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBOAEC READ WRITE NO
SQL> alter session set container=pdboaec; 切换到pdboaec服务;
SQL> alter pluggable database pdboaec open; 打开名称为pdboaec的pdb服务
SQL> create user hr identified by hr;
User created.
SQL> grant dba to hr;
Grant succeeded.
2.用Oracle SQL Developer 工具连接pdboaec服务
3.执行sql文档,