Re: I have a couple of questions

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:<6NlJa.72964$sm5.72743_at_rwcrnsc52.ops.asp.att.net>...
> comments embedded
> Jim
> "ultrium" <nkabbott_at_swbell.net> wrote in message
> news:xBlJa.3060$FB2.1504_at_newssvr31.news.prodigy.com...
> > I have a couple of questions. I am new to oracle, after have been using
> SQL
> > Server for several years. I installed the latest version(9.2.0.1.0) on a
> > win200 machine. I install a new user and give it Connect and resources
> > because that is what SCOTT have. I notice a couple of things. One is if I
> > have two or more connections as the new user, the connections can not see
> > any changes done by the other connections.
> Not until you commit with the other connection see the changed data. (See
> multiversioning in docs - or go to the asktom.oracle.com site)
>
> Also, the system account can not
> > see any table that the new user is using. I must be doing something wrong.
>
> You need to prefix the table name with the schema name to see it. (eg
> scott.emp) 2 users can share the same schema if the other user is granted
> privlidges and if they prefix the table with the schema name.
>
> > Does every user always have its own schema. Can two users share a schema?
> I
> > have a couple of oracle 8i books and they describe a system tablespace and
> a
> > data tablespace. It says of course the data should go to a date
> tablespace.
> > I noticed that there are no data tablespaces on my database. SCOTT and my
> > new user is using the system tablespace. This is right?
> No. Create a tablespace for them. Also should have a temporary tablespace
> and that should be of type temporary and all users should have this
> tablespace as their temporary tablespace. I usually call mine temp.
>
> Also forget what you learned with SQLServer; they are two different systems.
>
> I bet it is wrong.
> > Any replies would be appreciated.
> >

To add to the advice that Jim gave:
When you create a user always provide a default tablespace and assign their temporary tablespace. The only objects you want in the system tablespace are those objects created there as part of the Oracle database creation process or added when you run optional Oracle provided scripts: dbms****.sql and utl****.sql scripts for example.

In Oracle a schema is a user that owns objects. Depending on your application most users will probably not own objects. You may store the objects for an many different users (schemas) in a single tablespace as makes sense based on your application.

If you are going to be working in Oracle you will want to read the Concepts and DBA Administration manuals. As new people look over the manuals most recognize the importance of the DBA Admin manual, but the Concepts manual is the best place to start. The basics it provides are very helpful in understanding and remembering the contents of the other manuals.

IMHO -- Mark D Powell -- Received on Sun Jun 22 2003 - 19:37:41 CDT