Re: newbie to oracle

Użytkownik "Davide Sanna" <scaccopardo_at_tiscali.it> napisał w wiadomości news:c4u096$uub$1_at_lacerta.tiscalinet.it...
> Hi there,
> I'm using Oracle 9.2 on winNT.
> How can I create a schema that uses USERS tablespace?
> I've seen that I can use:
> CREATE USER your_username IDENTIFIED BY your_userpassword
> DEFAULT TABLESPACE users;
> but I'm using the Manager Console for this task,
> and user creation went successfully.
> Problem is that I don't see any new schema in schema node
> list in the Manager Console...

But you can see a new database user. ( Security/Users )

> What am I missing ?

Bet, you won't see unless you create at least one database object as this user.
Try to create a table and check 'schemas'.

--
TomekB