Re: newbie questions with Oracle 9i

KK wrote:
>
> Hi
>
> These are my questions.
>
> 1) I connect to Oracle9i using system/manager which is super user as I
> know.
> I created a new database using the above account. then was exploring
> the newly created database using Enterprice manager. I saw SYSTEM
> account is listed in that databases users list. but now it dosen't
> show there.!!! its vanished.. but still I can connect to the database
> as SYSTEM.. whats happening? and how can i get that user back ?
>

What means: "It doesn't show there"?

> 2) after login as system to the newly created database, I created a
> table, table schema name i choosed as same as the database name, and
> the tablespace i choosed as USERS [which was already there by default]
> table got created successfully.

This is not a question, is it?

>
> 3) Can i give permission to a user , for more than 1 table space ??
> apart from the temporary tablespace and default tablespace is it
> possible to add more tablespace for his access?

Yes you can grant any user quotas on any tablespace (limited or unlimited). But you should not grant quota for temporary tablespaces (TEMP), since nothing is stored there. The instance utilizies that only for auxiliary data.

>
> 4) Where the hell is Oracle SQL syntax help? :o) When I choose
> enterprice manager help, it dosen't seem to have any help about PL/SQL
> or SQL* help...

SQL has a help function, if properly installed (you need to load the help tables into the server). This is _not_ a SQL documentation. For this purpose consult your documentation CD or the Oracle TechNet, or buy some books.

U.

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!