oracle10g使用管道快速导入导出数据
oracle10g使用管道快速导入导出数据1、创建DIRECTORY创建存放目录:mkdir -p /home/oracle/dir_dp登录oracle命令行执行下面的命令:sqlplus / as sysdba;create directory dir_dp as '/home/oracle/dir_dp';2、授权tfcsm用户Grant read,write on directory dir_dp to tfcsm3、在终端命令行执行导出expdp tfcsm/*** schemas=tfcsm directory=dir_dp dumpfile=tfcsm.dmp logfile=tfcsm.expdp.log;导入impdp tfcsm/*** schemas=tfcsm directory=dir_dp dumpfile=tfcsm.dmp logfile=tfcsm.impdp.log;