oracle数据库备份及导入

步骤：

1.进入oracle服务器

2.进入oracle命令行，语句：sqlplus / as sysdba

3.在命令行内，创建逻辑目录，语句：create directory test_test as '/home/oracle/test';

4.在命令行内，给需要导入的用户授予逻辑目录权限，语句：grant read,write on directory test_test to backup_test;

5.在命令行内，给导入用户授予导入权限，语句：grant imp_full_database to backup_test;

6.退出命令行，exit;

7.执行导出数据库数据语句：expdp oracle_test_rafactor/oracle_test_rafactor@orcl schemas=oracle_test_rafactor dumpfile=oracle_test_rafactor.dmp directory=test_test;

8.执行导入数据语句：impdp backup_test/backup_test@orcl remap_schema=backup_test:oracle_test_rafactor directory=test_test dumpfile=oracle_test_rafactor.dmp;