conn sys/password as sysdba;
创建用户test1
CREATE USER test1 IDENTIFIED BY "pass1";
GRANT CONNECT TO test1;
GRANT DBA TO test1;
dumpfile默认文件路径
E:appAdministratoradminorcldpdump
导出数据库
expdp test1/pass1@orcl schemas=pass1 dumpfile=pass1.dmp
导入数据库
impdp test1/pass1@orcl dumpfile=pass1.dmp FULL=y;
注意:
exp导出来的用imp导入
expbd导出来的用impbd导入