OraFAQ Forum: Server Utilities » MP-00058: ORA-01950

Home » RDBMS Server » Server Utilities » MP-00058: ORA-01950 (Oracle 11.2.0.3.0 , Linux 5)

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

MP-00058: ORA-01950 [message #578041]

Sat, 23 February 2013 05:01

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I get import error while trying to import objects into schema.

Export file created by EXPORT:V11.02.00 via direct path
import done in US7ASCII character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing DEMO's objects into TEST
. . importing table                "TAB1"
IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USERS'

i understand we need to grant the user space resource on the tablespace as below.

ALTER USER <user> QUOTA UNLIMITED on <tablespace_name>

Please correct me if i am wrong.

My another question is can we grant QUOTA UNLIMITED on <tablespace_name> to user ?

Regards,
Jack

Report message to a moderator

Re: MP-00058: ORA-01950 [message #578042 is a reply to message #578041]

Sat, 23 February 2013 05:11

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

orcl> grant quota unlimited on users to scott;
grant quota unlimited on users to scott
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege


orcl> grant unlimited tablespace to scott;

Grant succeeded.

orcl>

but you shouldn't do this: unlimited tablespace is a very dangerous privilege.
--
edit: fixed code tags

[Updated on: Sat, 23 February 2013 05:12]

Report message to a moderator

Re: MP-00058: ORA-01950 [message #578043 is a reply to message #578042]

Sat, 23 February 2013 05:44

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

you shouldn't do this: unlimited tablespace is a very dangerous privilege.

And you shouldn't post this. Wink

A workaround that is posted even with a warning (even in bold, red, blinking) is a workaround that will be used, anyway.

What should be used is:

alter user scott quota unlimited on users;

And yes, this can be done... if you admit that SCOTT can occupy the whole tablespace; otherwise specify the quota you allow to SCOTT.

Regards
Michel

[Updated on: Sat, 23 February 2013 05:44]

Report message to a moderator

Previous Topic:	Tracing
Next Topic:	Import data type date from excel to oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 15:53:34 CST 2025