导出导入数据库

--查询数据库可用目录（导入导出数据库时可用）
SELECT * FROM dba_directories;
--查询表空间
select tablespace_name,file_id,bytes/1024/1024,file_name
　　 from dba_data_files order by file_id
--创建表空间
create tablespace BDC_GKCX_JOB_TEMP
datafile 'E:\ORACLEDATA\DATA\BDC_GKCX_JOB_TEMP.dbf'
size 10m
autoextend on next 20m maxsize 2048m

--导入数据库
impdp BDC_GKCX_JOB/sa123@32 directory=DIR_DP_IN_ALL dumpfile=BDC_GKCX20170104.DMP logfile =BDC_GKCX20170104_exp.log REMAP_SCHEMA=BDC_GKCX:BDC_GKCX_JOB REMAP_TABLESPACE=BDC_GKCX:BDC_GKCX_JOB

--导出数据库
expdp MHWZ/sa123@32 directory=DATA_PUMP_DIR dumpfile=MHWZ20170104.DMP logfile=MHWZ20170104_exp.log

expdp BDC_GKCX_SYS/sa123@oracl103 directory=DATA_PUMP_DIR dumpfile=BDC_GKCX_SYS20170104.DMP logfile=BDC_GKCX_SYS20170104_exp.log
--过滤表导出
expdp BDC_JOB/sa123@oracl directory=DATA_PUMP_DIR dumpfile=BDC_GKCX_JOB20170109.DMP logfile=BDC_GKCX_JOB20170109_exp.log tables=djb_bs, djb_cfdj