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搞定