OraFAQ Forum: Server Administration » More DB on the same instance...

Home » RDBMS Server » Server Administration » More DB on the same instance...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

More DB on the same instance... [message #179262]

Mon, 26 June 2006 09:38

Diego_IT
Messages: 7
Registered: June 2006
Location: Italy

Junior Member

I've 2 laptops with 2 different Oracle 9i DB and I would like move them to a server, but with only one instance, is it possible ? What can i do ?

The Oracle release is the same 9.2.0.1.0 but what if they were different like 9.2.... or 10?what will it happend?
Tx a lot for help
Diego

Report message to a moderator

Re: More DB on the same instance... [message #179267 is a reply to message #179262]

Mon, 26 June 2006 10:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I fail to read you.
There cannot be 2 databases with the same instance.
Every database can have only one instance in one host (A database can have N instances across N hosts. It is called as RAC).
In your case, what you can do is, Move/migrate those schema's/users from Database_2 into Database_1 or vice-versa.
Just export and import.

Report message to a moderator