Discussion on Multi-schemes Replacing Multi-instances in Oracle
Desheng Li · Hydropower Automation and Dam Monitoring · 2007
Aiming at the problem of the occupation of a large memery of Oracle multi-instances in the integration of water scheduling system,this paper proposes a new method to built multi-schemes in one instance.Multi-instances are replaced by multi-schemes,and the function of synonymy is used to map the database objects of different schemes,by which dummy multi-databases operation is realized.The advantages of the method are the use of single-instance,instead of multi-instances,to resolve the problem of occupation of a large memory,without the need of any other software support,and nice compatibility with the existing application software.