Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Binary types
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