Home » RDBMS Server » Server Utilities » MP-00058: ORA-01950 (Oracle 11.2.0.3.0 , Linux 5)
MP-00058: ORA-01950 [message #578041] Sat, 23 February 2013 05:01 Go to next message
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
Re: MP-00058: ORA-01950 [message #578042 is a reply to message #578041] Sat, 23 February 2013 05:11 Go to previous messageGo to next message
John Watson
Messages: 4672
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 Go to previous message
Michel Cadot
Messages: 59403
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Mon Oct 20 12:56:32 CDT 2014

Total time taken to generate the page: 0.09410 seconds