-----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 June 2004 5:07 PM To: 'Dusan Kolesar'; SAP DB mailing list Subject: AW: Database link in Oracle
Dusan Kolesar wrote: > > Hello, > Is it posible to divide one database into 2 or more instances ?? > Have I > access inside 1st instance to the 2nd ?? > > Something like "Database Link" and "Synonym" in Oracle. > http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCoo > kboo > k.html > See chapter: 4.2.3.1 Database Links >
MaxDB does not support database links --> no access from instance 1 to instance 2. If info is divided into several instances, the application has to take this into account and access partly here and partly there.
> Hi, > > I thought (from breifly reading the documentation) that this was similar to > what archive instances were for? (but obviously, potentially not as quick as > an OLTP instance) > > I was planning to research more and implement this feature (what I thought > was a feature at least) in the near future for our database. > > Is this not what archive instances are for/capable of?
the archive instance has additional support for special data volume types to handle large amounts of never changing data on HSM devices. It's on the application side to keep the 'live' data on the OLTP instance and the 'archive' data on an additional archive instance of MaxDB.
Henrik
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
