Oracle数据库移植技术探索

数据库移植是数据库系统维护中的一项重要工作,本文系统阐述了数据库移植的原则、方法和操作步骤。结合实际工作经验,对不同软硬件环境下把oracle10g数据库移植到oracle11g时出现的问题、以及相应的解决方法进行了归纳。可为软件开发和数据库维护人员提供一种比较实用的数据库移植方法,减少软件和数据库测试与维护工作中不必要的麻烦,提高工作效率。

Data base transplantation works as a significant procedure in maintaining the database system. This paper systematically explains the principles, methods, and operating procedures of date base transplantation. Combined with practical working experience, the problems that may occur while transplanting orade10g database to oracle11g under different software and hardware environment and the solutions to the problems also have been summarized in this paper, which can provide several instructive and practical methods of database transplantation for the software developers and database maintainers, and so as to avoid some unnecessary troubles in software and database testing and maintaining as well as to improve work efficiency.