Export with parameter file and import with same.
===============================================
Task : I am exporting some tables from CS and importing thsoe tables into BASKET schema.
/**************************************************** FILE NAME: exp_wo_data.par *******************/
userid=cs
file=exp_bskt_15MAR07.dmp
compress=N
grants=N
log=bskt_exp_15MAR07.log
ROWS=N
triggers=N
statistics=NONE
tables=(BSKT_AGENT_BASKET_CALL_DETAIL
, BSKT_AGENT_ORDER_NOTE
, BSKT_BASKET_ITEM_TYPE
, BSKT_DISCOUNT_APPLY_TYPE
, BSKT_DISCOUNT_REASON
, BSKT_ITEM_CALC_PRICING
, BSKT_ITEM_PRICING_XREF
, BSKT_ITEM_SUB_PRODUCT
, BSKT_PAYMENT_DETAIL
, BSKT_PAYMENT_METHOD_TYPE
, BSKT_PERSONALIZATION
, BSKT_PERSONALIZATION_STYLE
, BSKT_PRICE_ELEM_MSG_TYPE
, BSKT_PRICING_ELEMENT
, BSKT_PRICING_ELEMENT_MSG
, BSKT_PRICING_GROUP_TYPE
, BSKT_PRICING_TYPE
, BSKT_PRICING_VALUE_TYPE
, BSKT_PRIC_TYP_PRIC_GRP_XREF
, BSKT_RECIPIENT
, BSKT_RECIPIENT_MESSAGE
, BSKT_SESSION
, BSKT_SESSION_ATTRIBUTE_TYPE
, BSKT_SHOPPING_BASKET
, BSKT_SHOPPING_BASKET_ITEM
, BSKT_SHOPPING_BASKET_STATUS
, BASKET_ITEM_INVENTORY_XREF,
, AGENT_BASKETS
)
/*************************** Export command ********************************/
exp parfile=exp_wo_data.par
/***************************************** Import with parameter file, file name : imp_wo_data.par *******/
userid=basket
file=exp_bskt_15MAR07_wo_data.dmp
grants=N
log=imp_bskt_15MAR07_wo_data.log
ROWS=N
statistics=NONE
fromuser=CS
touser=basket
/************************************** Import command *******************/
imp parfile=imp_wo_data.par