RESUMO
This paper introduces the safe realization of ″No.1 Military″ database upgrade from ORACLE7.33 to ORACLE8I by import/export tools based on standby server.The establishment of standby server and the process of No.1 Military database upgrade are introduced detailedly in this paper.The database upgrade of other application system adopting ORACLE database system can refer to this paper.
RESUMO
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.