Re: I have a couple of questions

ultrium wrote:

> 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.
> > >
> > >
> >
> >

The similarities are fewer than the differences. The further into them you go the more differences you find.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)