Re: Ynt: Creation of Oracle databases

There appears to be some confusion about terms here; An Oracle instance is what many other databases call a database ( esp sqlServer and Access) It can, and usually does, have many schemas - that is, a set of objects ( tables,views,procs,etc) 'owned' by a particular Oracle account..

All schemas use the 'common' resources of the instance..

In short, the concept of 'multiple databases in a single instance' is incorrect when used in the Oracle context;

 Try http://technet.oracle.com and check out the Server Concepts docs for a better explanation of the Oracle structure and design..

schwickert_at_yahoo.com (T. Schwickert) wrote:

>Hi,
>
>no, I think not. It's possible to share ONE database in more
>instances (parallel Server), but in ONE instance there
>can only one database at a time.
>Nevertheless, one instance could handle more databases, but not at
>the same time.
>
>Hope I say some right :-)
> Thomas
>
>"Murat YILDIZ" <myildiz_at_bellona.com.tr> wrote in message
>> Apart from this thread, isn't it possible to create more than one database
>> within an instance?So that multiple databases uses the same Database
>> resources?
>>
>> Murat
>>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Jun 25 2001 - 11:55:06 CDT