当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

Oracle中imp导入相同的两个用户的数据


  操作系统为WIN2Kserver,数据库为817
  用户user022004对应表空间user022004用户user072004对应表空间user072004,现想将user072003用户的数据导入到user072004中。
  经过查找论坛中的资料总结如下:
  exp user022004/user022004@jhzy file=f:ackupuser022004.dmp
  OWNER=user022004 log=f:ackupuser022004.log
  create user user072004 identified by user072004 default
  tablespace user072004;
  GRANT CONNECT,RESOURCE,IMP_FULL_DATABASE TO user072004;
  revoke unlimited tablespace from user072004;
  alter user user072004 default tablespace user072004 quota
  unlimited on user072004;
  imp user072004/user072004@jhzy file=f:ackupuser022004.dmp
  ignore = y fromuser = user022004 touser = user072004 log=f:ackupuser072004.log
  关健是revoke unlimited tablespace from user072004;
  和alter user user072004 default tablespace user072004 quota
  unlimited on user072004;
相关内容
赞助商链接