OraFAQ Forum: Security => How to provide the table space?

Members

Help

Home

Home » RDBMS Server » Security » How to provide the table space? (oracle 10g)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

How to provide the table space? [message #319157]

Fri, 09 May 2008 03:37

mm_kanish05
Messages: 124
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

Report message to a moderator

Re: How to provide the table space? [message #319192 is a reply to message #319157 ]

Fri, 09 May 2008 05:19

Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

Use SQL*Plus and copy and paste your session.

Regards
Michel

Report message to a moderator

Re: How to provide the table space? [message #319362 is a reply to message #319157 ]

Sat, 10 May 2008 01:54

mm_kanish05
Messages: 124
Registered: January 2007
Location: Chennai

Senior Member

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

Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

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

Report message to a moderator

Re: How to provide the table space? [message #319366 is a reply to message #319157 ]

Sat, 10 May 2008 02:26

mm_kanish05
Messages: 124
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: 441
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.

Report message to a moderator

Re: How to provide the table space? [message #319368 is a reply to message #319157 ]

Sat, 10 May 2008 03:10

mm_kanish05
Messages: 124
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

flyboy
Messages: 441
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).

Report message to a moderator

Re: How to provide the table space? [message #319376 is a reply to message #319157 ]

Sat, 10 May 2008 04:27

mm_kanish05
Messages: 124
Registered: January 2007
Location: Chennai

Senior Member

sorry
im very new

can u give stright command for to recover my problem.

thank

kanish

Report message to a moderator

Re: How to provide the table space? [message #319378 is a reply to message #319157 ]

Sat, 10 May 2008 04:44

flyboy
Messages: 441
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.

Report message to a moderator

Previous Topic:	row level locking in oracle 9i
Next Topic:	Auditing DML - Terminal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 03:15:13 CDT 2008

Total time taken to generate the page: 27.73471 seconds

.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.