| Oracle 8i - newbie questions [message #54223] |
Tue, 05 November 2002 19:24  |
gogo
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
Hi,
I just installed Oracle 8i Personal edition on my notebook computer and I have several questions:
1. How can i know others such as ADAMS, CLARK, SCOTT, etc?
2. What does Roles mean? The user privilege like administrator?
3. Does one instance mean one database? Can one instance include more than one db?
4. Why I cannot run JServer? The error: "Failed to get a JServer service. Unknown OEM2." What does it mean? Is it because I am using 8i Personal version which does not support it?
5. There are a lot of schema. Can I use SYSTEM? or using SCOTT? or I need to create a new user?
6. When I create a table, it shows tablespace and there are users, tools, etc. Which one should I choose? Where could I set it's attributes? just follow the wizards?
7. In fact, I just want to (a) create a db; (b) create 4-5 tables with attributes; (c) try to learn SQL to retrieve the tuples; (d) using servlet to retrieve and submit data. Is there any good online tutorials for this aspect?
Thanks for your kind help.
gogo
|
|
|
|
|
|
| Re: Oracle 8i - newbie questions [message #54235 is a reply to message #54223] |
Wed, 06 November 2002 05:41  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
1-connect internal and query all_users
2-roles grant U system privileges .. but roles can u grant non-system privileges too. U create a role to store grant
example all u CLERK need to insert update delete on table CUSTOMER
create a role CLUERK_USER and grant it all privileges on CUSTOMER now just grant role CUSTOMER on all ur CLERK user and they can insert, update delete on CUSTOMER. ( easiest admin )
3-no & no
u can have two instances for one DB
4-don't know why
5-use SYS ans SYSTEM to create SYS or SYSTEM tables,function,procedure ONLY ! Never store DATA or INDEXES under those schema.
6-Must define which tablespace store DATA, TOOLS, INDEXES etc..
U can set attribute of a table in storage clause
U can set default attribute of a table in the default storage clause of the tablespaace
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
