Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie to oracle

Re: newbie to oracle

From: Noel <tbal_at_go2.pl>
Date: Tue, 6 Apr 2004 14:21:02 +0100
Message-ID: <c4u72m$rdm$1@inews.gazeta.pl>

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
Received on Tue Apr 06 2004 - 08:21:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US