Discussion on how to upgrade or migrate Oracle database / 医疗卫生装备

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.