Home » RDBMS Server » Security » How to provide the table space? (oracle 10g)
How to provide the table space? [message #319157] Fri, 09 May 2008 03:37 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

HI
I was created the user and logged in my session too.
when im trying to create the table. im getting the following error

Tables space for "USER" like some error

what it could be

wbr
kanish
Re: How to provide the table space? [message #319192 is a reply to message #319157] Fri, 09 May 2008 05:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.

Regards
Michel
Re: How to provide the table space? [message #319362 is a reply to message #319157] Sat, 10 May 2008 01:54 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

hi


PRIVILEGE
----------------------------------------
CREATE SESSION
CREATE TABLE


thanks for reply

wbr
kanish

[Updated on: Sat, 10 May 2008 02:24]

Report message to a moderator

Re: How to provide the table space? [message #319363 is a reply to message #319362] Sat, 10 May 2008 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not what I asked.
I don't see any error in your post.
I don't see any SQL query.
I don't see anything.

Quote:
Use SQL*Plus and copy and paste your session.


Regards
Michel
Re: How to provide the table space? [message #319366 is a reply to message #319157] Sat, 10 May 2008 02:26 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member


SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
CREATE TABLE

SQL> 



error

SQL> create table a (id number(3) primary key,
  2  name varchar2(30));
create table a (id number(3) primary key,
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'


SQL> 

[Updated on: Sat, 10 May 2008 03:07]

Report message to a moderator

Re: How to provide the table space? [message #319367 is a reply to message #319157] Sat, 10 May 2008 03:06 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Quote:
I don't see any error in your post.

Even I do not see any error. The SELECT statement was successful.
Maybe you have problem with another SQL statement.
But, as you do not post it here, it is hard to say more.
Re: How to provide the table space? [message #319368 is a reply to message #319157] Sat, 10 May 2008 03:10 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

please see my previous reply

again

kanish

[Updated on: Sat, 10 May 2008 03:21]

Report message to a moderator

Re: How to provide the table space? [message #319374 is a reply to message #319157] Sat, 10 May 2008 03:44 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
http://ora-01950.ora-code.com/
Quote:
ORA-01950: no privileges on tablespace 'string'
Cause: User does not have privileges to allocate an extent in the specified tablespace.
Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.

Use the QUOTA clause for USERS tablespace in CREATE USER / ALTER USER statements (you shall run it as a privileged user).
Re: How to provide the table space? [message #319376 is a reply to message #319157] Sat, 10 May 2008 04:27 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

sorry
im very new

can u give stright command for to recover my problem.

thank

kanish
Re: How to provide the table space? [message #319378 is a reply to message #319157] Sat, 10 May 2008 04:44 Go to previous message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
As you are member of this forum for over a year, I do not expect you to be very new to Oracle. Anyway you shall get used to be able to find information in the documentation, found eg. online on http://tahiti.oracle.com/.

ALTER USER is the desired statement, QUOTA is the clause you need to use. Alternatively have a look at CREATE USER statement for more info about QUOTA clause. If you do not want to restrict the user data size, specify it UNLIMITED.
Run it logged as a creator of that user.
Previous Topic: row level locking in oracle 9i
Next Topic: Auditing DML - Terminal
Goto Forum:
  


Current Time: Thu Mar 28 20:01:02 CDT 2024