Oracle数据库需报送以EXPDP方式导出的数据文件（dmp）和日志文件（log）

cw_t_pzlb

cw_zhangtao 有条件的导出
select * from cw_zhangtao 账套
where (tt_no = '02' or zt_no = 'GH')


select * from cw_km 科目

select * from DNC_XMDA 项目档案

select * from cw_commodity 商品

select * from CW_HGBMGL 海关编码

select * from cw_wldw 往来单位（含客户和工厂）

select * from T_CURRENCY (币别)

select * from t_country（国家）

select * from cw_department(部门)

select * from cw_employee(人员)

select * from cw_pz1_14

select * from cw_pz2_14

select * from T_CANGKU

先登录root ,再切换到oracle用户

su - oracle
df -h
sqlplus / as sysdba
 sql>  create  directory   expdpdir1  as '/home/oracle/expdpdir';
 sql>  grant  all  on  directory   expdpdir1  to public;
expdp  hysys/another directory=expdpdir1 tables= cw_t_pzlb,cw_km,DNC_XMDA ,cw_commodity,CW_HGBMGL,cw_wldw,T_CURRENCY,t_country,cw_department,cw_employee,cw_pz1_14,cw_pz2_14,T_CANGKU  dumpfile=expdptb.dmp logfile=expdp1.log  cluster=no