This content has been marked as final. Show 1 reply
amitavachatterjee1975 wrote:does 'DLDBO' have any quota on tablespace 'USERS'?
I have successdfully exported and created the export file through datapump export.
However during import I am getting this error
SQL> $impdp dldbo/pass111@WIQA DIRECTORY=pump_dir_trx DUMPFILE=wisc.dmp CONTENT=METADATA_ONLY
Import: Release 220.127.116.11.0 - 64bit Production on Monday, 07 January, 2013 14:56:51
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "DLDBO.SYS_IMPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 980
ORA-01950: no privileges on tablespace 'USERS'
I have given all necessary privileges like READ, WRITE to that dir, IMP_FULL_DATABASE even SYSDBA to user dldbo.
Please help as to how to get past this error.