documetumoracle數據庫遷移

　　源數據庫

　　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