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: Binary types

Re: Binary types

From: Marcus N Hofer <markus_at_tk136248.telekabel.at>
Date: Tue, 06 Apr 1999 07:14:18 GMT
Message-ID: <eviO2.23520$_k1.18088@news.chello.at>


<snip>

>Thanks Dogan,
>The problem is...I cannot find 'create schema' anywhere in the schema
manager.
>The only 'create' there is for all the schema objects, but nothing for a
new
>schema itself.

because it is 'create user'.

create user <name_of_schema> identified by <passwd> default tablespace <def_tabspc_name>
temporary tablespace <temp_tabsp_name;

grant connect to <name_of_schema>;

then grant the privileges You want to.

good luck,
--marcus

>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 06 1999 - 02:14:18 CDT

Original text of this message

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