Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!apple!usc!orion.cf.uci.edu!uci-ics!ucla-cs!jhwang
From: jhwang@CS.UCLA.EDU
Newsgroups: comp.databases
Subject: question about ingres star
Message-ID: <25638@shemp.CS.UCLA.EDU>
Date: 11 Jul 89 23:24:51 GMT
Sender: news@CS.UCLA.EDU
Reply-To: jhwang@CS.UCLA.EDU ()
Distribution: usa
Organization: UCLA Computer Science Department
Lines: 20

I tried to create a database "navy" with some of its relations allocated
at one site and the others at the other site. Here is what I did :

I created navy at one site "kingston" and copied all the data into
this site. Later, I went to second site "ipswich" and tried to 
create some new relations at this site. Firstly, I use create command
to create a new relation "test" and hope its data will be allocated at
this site. Unfortunately, this data goes to location (directory) under
the first machine.

I then tried to specify the second site while using the create command.
Nevertheless, I still got the error message like : 26826 Could not
find database default AREA in IILOCATIONS.

My questions are :

Is this the right way to do it ? or how can I allocate some relations
at one site and remaining relations at the other site ?

Any response is appreciated.