oracle exp 模糊表,oracle exp 排除指定的表导出其他所有表

排除指定的表导出其他所有表

1.查询排除的表的表名

select

listagg(table_name, ',') within group (order by table_name)

from dba_tables

where owner  in ('RUBICWARE')

and table_name not in

('INVENTORY_LOG')

order by owner;

2.整理导出命令

exp rubicware/wms@42DB file=c:\wms_20150305.dmp TABLES=(AISLE,BUFFER_LOCATION,CARRIER,CHUTE,CONFIGURATION,CONTAINER,HCOM_ARTICLE_DEL_LOG,HCOM_ARTICLE_INS_LOG,HCOM_BARCODE_DEL_LOG,HCOM_BARCODE_INS_LOG,HCOM_EMPTY_TU_LOG,HCOM_GOODSIN_AVAILABLE_LOG,HCOM_GOODSIN_CANCEL_LOG,HCOM_GOODSIN_INS_LOG,HCOM_GOODSIN_LINE_INS_LOG,HCOM_LOCATION_DEL_LOG,HCOM_LOCATION_INS_LOG,HCOM_PICKORDER_CANCEL_LOG,HCOM_PICKORDER_ERROR_LOG,HCOM_PICKORDER_FINISHED_LOG,HCOM_PICKORDER_INS_LOG,HCOM_PICKORDER_LINE_INS_LOG,HCOM_PICKORDER_RESP_LINE_LOG,HCOM_PICKORDER_RESP_LOG,HCOM_PICKORDER_STATION_RESPLOG,HCOM_S2W_PICKORDER_START_LOG,HCOM_STOCK_ADJUSTMENT_LINE_LOG,HCOM_STOCK_ADJUSTMENT_LOG,HCOM_STOCK_BALANCE_LOG,HCOM_STORAGE_LOC_INFO_LOG,HCOM_TRANSFER_SSI_WEIWUDE_LOG,HCOM_TRANSFER_WEIWUDE_SSI_LOG,HCOM_TRANSPORT_ERROR_RESP_LOG,HCOM_TRANSPORT_ORDER_INS_LOG,HCOM_TRANSPORT_RESP_LOG,HCOM_TU_STATUS_LOG,HCOM_W2S_PICKORDER_START_LOG,INVENTORY,INVENTORY_EXP,INVENTORY_LOT,JOB,JOB_DETAIL,JOB_FLOW,LOCATION,LOC_COLLECTION,LOC_COLLECTION_R,OWNER,PACKAGE_MATERIAL,PACK_ERR_SRC_BARCODE,PHYSICAL_ZONE,PHYSICAL_ZONE_LOCATION_R,PICKING_ZONE,PICKING_ZONE_LOCATION_R,PICKING_ZONE_REPLENISH_CONFIG,PICKING_ZONE_SEQ,PRINTER,PRINTER_COMBO,PUTAWAY_STRATEGY,PUTAWAY_STRATEGY_SEQ,RECEIVING_PLAN,RECEIVING_PLAN_DETAIL,RECEIVING_PLAN_DETAIL_LOG,RECEIVING_PLAN_LOG,RETRIEVAL_ORDER,RETRIEVAL_ORDER_BATCH,RETRIEVAL_ORDER_DETAIL,RETRIEVAL_ORDER_DETAIL_LOG,RETRIEVAL_ORDER_LOG,RETRIEVAL_ORDER_SYN,RETRIEVAL_STRATEGY,RETRIEVAL_STRATEGY_SEQ,SCS_FACTILITY_INV,SCS_INVT_EXP,SCS_INVT_SUM,SCS_LOCATION_SKU,SCS_OWNER_CONFIG,SCS_PICKING_CONFIGURATION,SHOP,SKU,SKU_COMB,SKU_CONFIG_GROUP,SKU_EXP,SKU_GROUP,STATION,STO,STORAGE_ZONE,STORAGE_ZONE_LOCATION_R,TERMINAL_PRINTER,TRANSPORT_JOB,WAMASCMESSAGEWORK,WAMASCMESSAGEWORKHISTORY,WAMASCPICKWORKDETAILRESULT,WAMASCPICKWORKRESULT,WAMASCTRANSPORTWORK,WAMASCTRANSPORTWORKDETAIL,WAMASCTRANSPORTWORKHISTORY,WMASCPICKWORK,WMASCPICKWORKDETAIL,WMASCPICKWORKDETAILHISTORY,WMASCPICKWORKHISTORY,WMS_WAMASC_BALANCE,ZONE)