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: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 06 Apr 1999 08:27:06 -0700
Message-ID: <370A27CA.CBE85E3E@us.oracle.com>


There is actually a create schema command, but I've never found a use for it myself. Presumably it's not there in the GUI (I haven't looked for it to confirm that).

HTH. Pete

Marcus N Hofer wrote:

> <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

--

Regards

Pete


Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)
San Francisco

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA



Received on Tue Apr 06 1999 - 10:27:06 CDT

Original text of this message

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