Re: Oracle Create User Problem

Rajesh wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F4CE2FF.90CF4999_at_exxesolutions.com>...
> > Rajesh wrote:
> >
> <snipped>
>
> Thanks! Daniel.
> Ho!, i used UNLIMITED, This is other issue which not sure how do i
> calculate the tablespace and table size or storage options? like
> INITIAL or NEXT or MINEXTENTS or MAXEXTENTS....Any excel sheet or a
> tools available to do it. Are their any MATH to easy the calculation.
>

Unlimited is only an issue if you run out of space. Just keep an eye on usage. What you don't want to do is give the SYSTEM privilege unless you also:

ALTER USER <user_name>
QUOTA 0 ON SYSTEM; for every user except SYS and SYSTEM.

>
> User Creation above used only in 8i Since In 9i it is locally managed.
> Is that the reason, i get the below error when creating TEMPERARY
> tablespace?
> ERROR at line 1:
> ORA-12913: Cannot create dictionary managed tablespace.
> Do i have change any params to resolve this?

If you have a running Oracle database it is highly unlikely you need to create a temporary tablespace: What makes you think one doesn't already exist?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)