Re: Create Schema

From: Lord'N'Master <keithu1_at_yahoo.com>
Date: 20 Jun 2006 08:15:37 -0700
Message-ID: <1150816537.173831.166560@y41g2000cwy.googlegroups.com>

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