Thanks for the help. I have notice that Oracle and SQLServer are alot
different. They are more different than I thought they would be.
"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.
> >
> >
>
>
Received on Sun Jun 22 2003 - 15:40:43 CDT
