| How to provide the table space? [message #319157] |
Fri, 09 May 2008 03:37  |
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 #319366 is a reply to message #319157] |
Sat, 10 May 2008 02:26  |
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 |
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 #319374 is a reply to message #319157] |
Sat, 10 May 2008 03:44 |
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 #319378 is a reply to message #319157] |
Sat, 10 May 2008 04:44 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
