Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Create User Problem
How can you have multiple default tablespaces?
What would that mean?(pick one?)
You only get 1 default tablespace. Also it is a good practice to specify
your temporary tablespace also.(for sorting) Usually you specifically
create a temp tablespace, so you want to specify it so people will use it.
Jim
"Rajesh" <action_at_tarangtech.com> wrote in message
news:56610888.0308260730.6a0e148b_at_posting.google.com...
> I have a script to create all the tablepaces from tb1 to tb4.
>
> And when i run the below create user script, I get the error in the
> sql option.
> Are the below line is synataxically wrong, anybody please suggest?
>
> CREATE USER <username> IDENTIFIED BY <password> DEFAULT TABLESPACE
> tb1, tb2, tb3, tb4 PROFILE DEFAULT;
>
> Whether it hold good for both Oracle 8i and 9i?
>
> Thanks in advance.
Received on Tue Aug 26 2003 - 10:37:00 CDT
![]() |
![]() |