Re: Use of Temp Table and Two DB problem

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.

You should post some more info about OS and version of oracle.

>
> 2)I would like to know can I create a temp table similar to temp table

If tthe only task of the temporary table is to indicate to other clients that one instance of the program is running soon then you should think about some kind of reference counter held in a "normal" table.

>
> in MS-SQL and Sybase, when the connection lost the table will be delete
> automatically. Or is there any substitution for it?
>
> It is because I my migrating my system from MS-SQL to Oracle 8 while
>
> one of the vital function is utilising the temp table to notify the
> other
> client program in network about existence of the program.
>
> Thank you for your attention.
>
> Thank you for your attention
>
> Kevin
 

-- 
Regards

Matthias Gresz    :-)