OraFAQ Forum: SQL & PL/SQL » Creating a new user and tablespace

Home » SQL & PL/SQL » SQL & PL/SQL » Creating a new user and tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating a new user and tablespace [message #3431]

Thu, 26 September 2002 05:34

Arindam
Messages: 8
Registered: May 2002

Junior Member

How can I create a new User and table space in Oracle SQL Plus ?

How to create a new Session ? Pls help me.

Report message to a moderator

Re: Creating a new user and tablespace [message #3432 is a reply to message #3431]

Thu, 26 September 2002 06:56

B
Messages: 327
Registered: August 1999

Senior Member

user:
sqlplus>create user [[NAME]] identified by [[PASSWORD]];

don't forget to grant role or the user can't even connect

tb:
sqlplus> create tablespace [[NAME]] datafile '[[FILE - FULL PATH]]' size [[SIZE]];

[[SIZE]]=500M ( 500 Mo ) or SIZE=500K (500 Ko )

Report message to a moderator

Re: Creating a new user and tablespace [message #3443 is a reply to message #3431]

Thu, 26 September 2002 21:11

gp
Messages: 46
Registered: September 2002

Member

for user
create user <name> identified by <password> default tablesapce <tbalespace name> temporary tablespace temp;
if u dont specify table space name it will take system as default.
for table space B's sytex can be used u just need to look in what all other parameters u need..

Report message to a moderator

Previous Topic:	stumped Select Rpad
Next Topic:	How can a DBA influence all sessions currently logged in to an instance? Broadcast?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 19:30:04 CDT 2024