导出单张表的数据

exp CX_NEWAPAS/[email protected] FILE=”G:\LineWell\OA\APAS_INFO.dmp” TABLES=(CX_NEWAPAS.APAS_INFO) LOG=”exp.log”

导出全部表的数据

exp system/oracle file=’data/wys_um.dmp’ owner=wys_um

exp system/oracle file=’data/wys_was.dmp’ owner=wys_was

exp system/oracle file=’data/wys_workflow.dmp’ owner=wys_workflow

执行sql

sqlplus system/oracle @createTableSpaceAndUser.sql

导入

imp system/oracle tablespaces=’XS_UM’ file=’um_星期三.dmp’ fromuser=xs_um touser=xs_um log=’um.log’ ignore=y

imp system/oracle tablespaces=’XS_WORKFLOW’ file=’workflow_星期三.dmp’ fromuser=xs_workflow touser=xs_workflow log=’workflow.log’ ignore=y

imp system/oracle tablespaces=’XS_WAS’ file=’was_星期三.dmp’ fromuser=xs_was touser=xs_was log=’was.log’ ignore=y