数据库导入

进入数据库创建目录、用户表空间和用户

sqlplus / as sysdba(下面依次输入以下命令后回车)
> create directory gjtdb as '/home/oracle/';
> create tablespace tp datafile '/oracle/oradata/ORCL/orclpdb1/tp01.dbf' size 50m autoextend on next 50m maxsize unlimited
> create user tp_sems identified by ****** default tablespace tp temporary tablespace temp;
> grant dba to tp_sems;
> exit

上传准备好的数据备份dmp文件，用导入命令进行导入

impdp tp_sems/******** directory=gjtdb dumpfile= gjtdb.dmp full=y

等待命令执行完成后数据就成功导入

/