登录sys超级用户，查看PDB容器名
show pdbs
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ORCLPDB READ WRITE NO
比如显示ORCLPDB
使用sys用户登录到PDB
conn sys/密码@localhost:1521/ORCLPDB as sysdba;
创建scott用户
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;
ALTER USER SCOTT DEFAULT TABLESPACE USERS;
ALTER USER SCOTT TEMPORARY TABLESPACE TEMP;
解锁scott用户：
alter user scott account unlock;
登录scott用户
conn scott /tiger@localhost:1521/ORCLPDB;
导入scott用户的表，找到WINDOWS.X64_193000_db_home\rdbms\admin\scott.sql文件里面的建表和数据SQL语句
验证数据
select * from emp;
PL/SQL Developer登录scott用户
用户名：scott
密码：tiger
数据库：localhost:1521/ORCLPDB
连接为：Normal