Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create Schema
Fully Agree with Sybrand Bakker.
Check if you have created a user with O.S authentication ,if yes it will have a preffix of 'OPS$'
Anyways just posting to you the basic command for creating a user in Oracle (with the assumption that ur connected to the Oracle Database)
SQL>
Create user <Username> identified by <Password>
default tablespace <Default tablespace name>
Temporary Tablespace <Temp Tablespace name>;
Regards Received on Tue Jun 20 2006 - 10:15:37 CDT
![]() |
![]() |