Upgrading No.1 Military Medical Project database from Oracle 8.17 to Oracle 11g / 医疗卫生装备

ABSTRACT

Objective To upgrade No.1 Military Medical Project database from Oracle 8.17 to Oracle 11g so as to solve the problems of server overloading and client terminal failing to connect to the server due to excessive concurrent databases. Methods Exp/Imp and Toad tools of the database were used to generate and modify the upgrade statements as well as to import and export database data,so that the inter-platform and-version database upgrade could be carried out.Results The database was upgraded and the system's operation speed was enhanced greatly.Conclusion The upgrade scheme has easy operation,short time consumed,zero data loss and high reliability,and thus is worthy promoting in medium-and small-scale hospitals.