Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> I have a couple of questions
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. Also, the system account can not
see any table that the new user is using. I must be doing something wrong.
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? I bet it is wrong.
Any replies would be appreciated.
Received on Sun Jun 22 2003 - 12:22:37 CDT
![]() |
![]() |