Re: Oracle Create User Problem

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 26 Aug 2003 19:26:48 +0300
Message-ID: <3f4b8a4a$1_1@news.estpak.ee>

You can have only one default tablespace.

Tanel.

"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 - 11:26:48 CDT