advertisements
_____________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment