Re: database, tablespace, user confusion

On Thu, 28 Aug 2003 11:25:12 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:

>
>
>Ed Stevens <nospam_at_noway.nohow> wrote:
>
>>On 28 Aug 2003 05:07:26 -0700, tridentadm_at_netscape.net (DukeNM) wrote:
>>
>>>i am newbie to oracle dba. (and even oracle i guess)
>>>
>>>but anyways comming to the point...
>>>i am getting a little bit confused on
>>>create user
>>>create tablespace
>>>create database
>>>
>>>if a tablespace is logical specification of physical datafiles
>>>
>>I think you're looking through the wrong end of the telescope. A
>>tablespace is a logical structure that is implemented within one or
>>more physical files. A tablespace may be associated with one or more
>>files, but a file can be associated with only one tablespace.
>>
>>In other words, a file (or collection of files) contain the logical
>>structure known as a "tablespace." A single tablespace may be
>>contained within multiple files, but any given file can contain only
>>one (or a part of one) tablespace.
>>
>>>what does database do??
>>
>>It manages data . . .
>>
>>Which even though that's what you asked, I suspect is not what you
>>meant. ;-)
>>
>>A database is a logical entity made up of multiple tablespaces (see
>>above) as well as several other files that are not related to
>>tablespaces. In addition, there are the executing processes and
>>memory structures (an "instance") that are sometimes loosely thought
>>of as being part of the database.
>>
>>
>>This is Oracle's meaning of the word "database." In SQL-Server, the
>>word "database" means something entirely different. In that system
>>"database" refers to the collection of objects (tables, indexes, etc.)
>>that belong to a given username. In Oracle, this is called a
>>"schema."
>>
>>
>>HTH
>
>Please, please,please read the Concepts manual ( at least) .

I have. And after seeing your reply, I re-read my post to see what I mis-stated, and I'm missing it. I don't claim to be a great DBA, but there are a few things i feel pretty sure of. Exactly what did I mis-state? Honestly, I'm not trying to pick a fight here. If I mis-stated or mis-led in my post, I *really* want to know what it was.

"A database is a logical entity made up of multiple tablespaces (see above) as well as several other files that are not related to tablespaces." Is this false or misleading?

"In addition, there are the executing processes and memory structures (an "instance") that are sometimes loosely thought of as being part of the database. " Is this false or misleading?

"This is Oracle's meaning of the word 'database.' In SQL-Server, the word "database" means something entirely different." Is this false or misleading?

" In that system 'database' refers to the collection of objects (tables, indexes, etc.) that belong to a given username." Is this false or misleading?

" In Oracle, this is called a 'schema.'" Is this false or misleading?

>New to Oracle and new to Oracle DBA is a path to frustration and/or disaster without a solid understanding of the
>architecture and design behind this complex RDBMS..We were all there once, and there is no easy path to this beast..but the
>trip is worth it.
>
>Enjoy the journey..
>
>John
>
Received on Fri Aug 29 2003 - 07:29:56 CDT