Discussion on how to upgrade or migrate Oracle database
- VernacularTitle:Oracle数据库升级或迁移的方法探讨
- Author:
Changming LIANG
;
Gongzhi YUAN
;
Zhanwei QIN
;
Bin CHEN
- Publication Type:Journal Article
- Keywords:
database upgrade;
DBUA;
export/import;
tablespace transport;
materialized view
- From:
Chinese Medical Equipment Journal
1989;0(01):-
- CountryChina
- Language:Chinese
-
Abstract:
Objective To upgrade Oracle database to Oracle 10g Release 2 in No.1 Military Medical Project. Methods Technologies such as database upgrade assistance, manual script upgrade, exp/imp(expdp/impdp)of DBUA, transportable tablespace, materialized view and table copy were used to upgrade Oracle database respectively. Results It showed that all of these methods could upgrade Oracle database. Conclusion Although all of these methods can upgrade Oracle database, there are differences in their procedures and efficencies, so suitable methods should be chosen according to practical situation.
