Re: I have a couple of questions

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.
>
>
Received on Sun Jun 22 2003 - 12:34:58 CDT