Oracle 导入导出操作

【root用户下】
mkdir /home/dmp
chown oracle:oracle -R /home/dmp
chmod 755 /home/dmp
把sisp_test20231125.dmp文件发到/home/dmp目录，没有就创建目录并放入

su - oracle

sqlplus / as sysdba

CREATE DIRECTORY dmp01 AS '/home/dmp';

create user susp_test identified by Tecsun_2205;
grant create session to susp_test;
grant connect to susp_test;
grant resource to susp_test;
grant dba to susp_test;
grant read.write on directory dmp01 to sisp_test;
impdp \\"susp_test/Tecsun_2205 as sysdba\\" directory=dmp01 DUMPFILE=sisp_test20231125.dmp FULL=YES
6//////