Fix IMP-00058: ORACLE error 1950 encountered


Error Description:
Import using conventional imp utility is failing with following error.

IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USERS'
Import terminated successfully with warnings.

Solution Description:
Imp utility is trying to create the object under the user x. But for that particular user doesn’t have privilege or quota allocated on that particular tablespace (USERS). DBA has to grant sufficient space quota for that user on the particular tablespace which is mentioned in the error message. The syntax is as follows.

alter user <username> quota <k/m/unlimited> on <tablespace_name>;
Example

imp file=exp_schema.dmp log=imp_exp_schema.log fromuser=scott touser=test

Import: Release 11.2.0.2.0 - Production on Mon Oct 15 02:05:35 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: test/test

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by SCOTT, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing SCOTT's objects into TEST
. . importing table                      "BL_TEST"
IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USERS'
Import terminated successfully with warnings.


SQL> alter user test quota unlimited on users;

User altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google