Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create Schema

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

Original text of this message

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