某公司OA系统ecology用户数据exp/imp实例

1、导出导入ecology用户所有表

exp system/password@fsoa file=d:\ecology.dmp owner=(ecology);

imp ecology/ecology@myoa fromuser=ecology touser=ecology file=d:\ecology.dmp ignore=y;

注意：导入前请先删除myoa中ECOLOGY用户的所有表

2、导出导入voting表

exp ecology/ecology@fsoa file=f:\vote.dmp log=f:\vote.log tables=(voting,votingoption,votingquestion,votingremark)

imp ecology/ecology@myoa file=z:\Share2CentOS\vote.dmp full=y