Re: Use of Temp Table and Two DB problem

Matthias Gresz wrote:
>
> Beginner wrote:
> >
> > Hi,
> >
> > I am very new in Oracle, please forget my about some fundmental
> > questions.
> >
> > 1)I would like to create two database in Oracle 7, one is called
> > Personnel and another is called Sales, but I cannot find any way to do
> > this. When I create the other instance, the other will be stopped
> > automatically or vice versa.
> >
> > I would like to know is there any way to create two separately
> > instance in Oracle 7 and 8 as I will migrate to v.8 very soon.

Consider using a single Oracle instance (database) rather than two. Oracle and MS SQL Server use the word "database" with different meanings. In Oracle simply create a username for Personnel and another for Sales. Received on Wed Nov 26 1997 - 00:00:00 CET