Re: Ora10g installed...now what ? :-)

From: Bob Jones <email_at_me.not>
Date: Thu, 17 Aug 2006 00:11:59 GMT
Message-ID: <jvOEg.11536$o27.8670@newssvr21.news.prodigy.com>

> Can you explain me please in simple terms the difference from "database"
> term in sql server 2000 and Oracle?
>
> - Does an instance of Oracle contain one or more databases ?

No, unlike SQL Server, an instance cannot mount more than one databases at the same time.

> - What is exactly a "schema" ?

I will let you read the Concept manual on this one.

> - Is a tablespace like a database ? What is the difference from tablespace
> of Ora and database of Sql server?
>

A tablespace in Oracle is similar to a file group in SQL Server. Received on Wed Aug 16 2006 - 19:11:59 CDT