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 -> Oracle Create User Problem

Oracle Create User Problem

From: Rajesh <action_at_tarangtech.com>
Date: 26 Aug 2003 08:30:05 -0700
Message-ID: <56610888.0308260730.6a0e148b@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:30:05 CDT

Original text of this message

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