熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

documetumoracle數據庫遷移

2013-11-13 15:32:45  來源: Oracle 

  源數據庫

  exp userid=system/pwd@orcl file=D:\share\dbbackup\whyxdoc_dmp log=d:\share\dbbackup\whyxdoc_log owner=whyxdoc buffer=

  目標數據庫

  drop tablespace DM_WHYXDOC_DOCBASE  and datafiles;

  drop tablespace DM_WHYXDOC_INDEX  and datafiles;

  drop user WHYXDOC cascade;

  create tablespace DM_WHYXDOC_DOCBASE DATAFILE D:\app\dmadmin\oradata\orcl\DM_WHYXDOC_DBDBF SIZE M AUTOEXTEND ON;

  create tablespace DM_WHYXDOC_INDEX DATAFILE D:\app\dmadmin\oradata\orcl\DM_WHYXDOC_INDDBF SIZE M AUTOEXTEND ON;

  create user WHYXDOC identified by pwd default tablespace DM_WHYXDOC_DOCBASE ;

  grant  dbaconnectresourcecreate view to WHYXDOC;

  imp userid=system/pwd@orcl fromuser=whyxdoc touser=whyxdoc file=D:\share\dbbackup\whyxdoc_dmp log=d:\share\dbbackup\whyxdoc_log buffer=

  數據庫遷移好後修改documetum所使用數據庫連接文件中的HOST地址為新服務器地址或使用Net Manager修改該地址也可

  重啟documentum搞定


From:http://tw.wingwit.com/Article/program/Oracle/201311/16891.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.