数据库泵导出文件到asm磁盘组里
1. For example, you would create a directory object in the ASM diskgroup to place the dump file as follows
SQL> CREATE DIRECTORY ASM_DIR_DUMP as '+DISKGROUP1/export';2. Then you would create a separate directory object for the export & import log files in normal OS file system:
SQL> CREATE DIRECTORY ASM_DIR_LOG as '/user1/backup/';
3. To enable user SCOTT to have access to these directory objects, you would assign the necessary privileges,
SQL> GRANT READ, WRITE ON DIRECTORY ASM_DIR_DUMP TO scott;
SQL> GRANT READ, WRITE ON DIRECTORY ASM_DIR_LOG TO scott;
4. Then you would then use the following Data Pump Export command:
$ expdp scott/tiger DIRECTORY=ASM_DIR_DUMP DUMPFILE=scott.dmp LOGFILE=ASM_DIR_LOG:scott.log tables=emp
5. Then use the following Data Pump Import command:
$ impdp scott/tiger DIRECTORY=ASM_DIR_DUMP DUMPFILE=scott.dmp LOGFILE=ASM_DIR_LOG:scottimp.log
并行导入导出:
impdp \"sys/oracle as sysdba\" directory='ASM_DIR_DUMP' dumpfile=b20140819%U.dmp logfile=ASM_DIR_LOG:asmtwoci.log parallel=6 cluster=N
expdp \"sys/oracle as sysdba\" schemas='(user1,user2...)' dumpfile=asm%U.dmp logfile=DUMP:asm12.log directory=ASMDIR compression=all PARALLEL=12 filesize=300M