Home » RDBMS Server » Server Administration » Tablespace & Users
Tablespace & Users [message #53407] Wed, 18 September 2002 05:23 Go to next message
Mostafa
Messages: 8
Registered: September 2002
Junior Member
how can i assign tablespace to a certain user?

Report message to a moderator

Re: Tablespace & Users [message #53408 is a reply to message #53407] Wed, 18 September 2002 05:38 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
while creating the user:
[code]create user user1 identified by user1
default tablespace tab1
temporary tablespace tab2;
[code]else
after creating the user
alter user user1 default tablespace tab3;

Report message to a moderator

Previous Topic: How to log into OEM
Next Topic: Force end users to use other reporting tools not SQL*PLUS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 29 04:04:40 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.