기술관련/oracle

oracle export import option

흰머리개발자 2005. 1. 5. 16:44
//-------------------
//table 설정 export
//-------------------
set ORACLE_SID=SP

exp system/manager@sp file=c:expXXXS010TB.dmp log=c:explogXXXS010TB.log tables=XXX_XXX.XXXS010TB direct=y

//-------------------
//user설정 export
//-------------------
set ORACLE_SID=SP

exp system/manager@sp file=c:expXXX_XXX.dmp log=c:explogXXXX001TB.log owner=XXX_XXX direct=y

//-------------------
// import
//-------------------
set ORACLE_SID=SP

imp system/manager@sp file=c:expXXXS010TB.dmp log=c:explogXXXS010TB.log ignore=y fromuser=XXX_XXX touser=XXX_XXX rows=y indexes=y