oracle exp imp

garydo

exp lxtest\lxtest@CCS file=\home\db1.dmp tables=BOOKMARK,IPSCOPE,HYPY,REFERER,PERSONNELCARD,T_PERSONNEL_BASEINFORMATION,T_USER_TITLE,T_TITLE,T_PERSONNEL_COMMONCOLUMN,T_SUBJECT,T_GROUP,T_GROUP_GROUP,T_GROUP_USER,T_NAVIGATIONGROUP,T_CUSTOMGROUP,T_CUSTOMGROUP_GROUP,T_CUSTOMGROUP_USER,T_NAVIGATIONGROUP_GROUP,T_NAVIGATIONGROUP_USER,WEBSITE,WEBLOGCATEGORY,WEBLOGENTRY,WEBLOGTOPIC,WEBLOGCOMMENT,WEBLOGSETTINGS

imp ccs\ccs@CCS fromuser=lxtest touser=lxpage rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=homedb1.dmp log=homedb1.log

imp ccs\ccs@CCS fromuser=lxtest touser=lxpage rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=homedb1.dmp tables=BOOKMARK,IPSCOPE,HYPY,REFERER,PERSONNELCARD,T_PERSONNEL_BASEINFORMATION,T_USER_TITLE,T_TITLE,T_PERSONNEL_COMMONCOLUMN,T_SUBJECT,T_GROUP,T_GROUP_GROUP,T_GROUP_USER,T_NAVIGATIONGROUP,T_CUSTOMGROUP,T_CUSTOMGROUP_GROUP,T_CUSTOMGROUP_USER,T_NAVIGATIONGROUP_GROUP,T_NAVIGATIONGROUP_USER,WEBSITE,WEBLOGCATEGORY,WEBLOGENTRY,WEBLOGTOPIC,WEBLOGCOMMENT,WEBLOGSETTINGS

exp lxtest\lxtest@CCS file=\home\db2.dmp tables=T_NAVIGATIONGROUP_USER,WEBSITE,WEBLOGCATEGORY,WEBLOGENTRY,WEBLOGTOPIC,WEBLOGCOMMENT,WEBLOGSETTINGS

imp ccs\ccs@CCS fromuser=lxtest touser=lxpage rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=homedb2.dmp log=homedb2.log

exp lxtest\lxtest@CCS file=\home\db3.dmp tables=V_BLOG_PERSONNEL_INFORMATION,V_JXXX_RKXX,V_KJXM_CJXMRY,V_KJXM_KYXM,V_KYJG_GRJGJS,V_LLXX_JLXX,V_SKXM_CJXMRY,V_SKXM_KYXM,V_XSCG_JBXX,V_XSCG_XGRY,V_XSHD_HYJLQK,V_XSLW_JBXX,V_XSLW_XGRY,V_XSRY_BCXX,V_XSRY_JBXX,V_XSRY_JBXX_LOGIN,V_XSZZ_JBXX,V_XSZZ_XGRY,V_ZLCG_JBXX,V_ZLCG_ZLRY,V_ZXBZ_CGJLDJ,V_ZXBZ_CGJLLB,V_ZXBZ_DW,V_ZXBZ_KWXNJB,V_ZXBZ_XB,V_ZXBZ_XMLY,V_ZXBZ_XSLB,V_ZXBZ_ZLLB,V_ZXBZ_ZYJSZW

imp ccs\ccs@CCS fromuser=lxtest touser=lxpage rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=homedb3.dmp log=homedb3.log