Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Create User Problem
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
![]() |
![]() |