Oracle10g use pipelines to quickly import and export data

Oracle10g use pipelines to quickly import and export data 1. Create a DIRECTORY and create a storage DIRECTORY: mkdir-p/home/oracle/dir_dp. log on to the oracle command line and execute the following command: sqlplus/as sysdba; create directory dir_dp as '/home/oracle/dir_dp'; 2. Authorize the tfcsm user to Grant read, write on directory dir_dp to tfcsm 3. Execute export expdp tfcsm/*** schemas = tfcsm directory = dir_dp dumpfile = tfcsm on the terminal command line. dmp logfile = tfcsm. expdp. log; import impdp tfcsm/*** schemas = tfcsm directory = dir_dp dumpfile = tfcsm. dmp logfile = tfcsm. impdp. log;