用Shell命令进行导入导出操作:
exp导出表
exp gjjs/gjjs!sh@zwjs file=/gjjs/tmp/201505/sql_20150721.dmp tables=c_report_sql,c_sheet_sql,d_sheet_head
imp导入
gjjs/1qaz!QAZ@gjjs file=/gjjs/tmp/201505/sql_20150721.dmp full=y ignore=y buffer=10240000 COMMIT=Y
exp导出表
exp gjjs/gjjs!sh@zwjs file=/gjjs/tmp/201505/sql_20150721.dmp tables=c_report_sql,c_sheet_sql,d_sheet_head
imp导入
gjjs/1qaz!QAZ@gjjs file=/gjjs/tmp/201505/sql_20150721.dmp full=y ignore=y buffer=10240000 COMMIT=Y