Re: newbie to oracle

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Tue, 06 Apr 2004 16:29:53 GMT
Message-ID: <5WAcc.7518$Sh4.5042@edtnps84>

Davide Sanna wrote:

> Hi there,
>
> I installed Oracle 9i trial version for WinNT.

Actually you installed the production version of the database. Oracle does not have trial versions.

> I created an user just to try to create and manage some tables.
>
> I gave this user DBA privileges.
>
> I've seen that USER tablespace is assigned by default, and this is ok.
> Why can I see tables only in schemas, and not in tablespaces ?
>
> Should I have to create some schema ?
> How can I use a schema associated with USERS tablespace ?

For your purposes now, a schema is simply the dictionary owned by a userid. Creating anything such as a table or view will 'create a schema'. The resource restrictions, such as default tablespace or quota, are attached to the user managing/owning the schema.

I strongly encourage you to read the concepts manual. It's available at http://docs.oracle.com This an da LOT more is explained. After reading that the Database Administration Guide (which should be your second reference book) will make sense.

/Hans Received on Tue Apr 06 2004 - 11:29:53 CDT