This discussion is archived
1 Reply Latest reply: Jan 7, 2013 12:06 PM by amitavachatterjee1975 RSS

Error while doing datapump import

amitavachatterjee1975 Newbie
Currently Being Moderated
Hi Gurus,

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 11.1.0.7.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 11.1.0.7.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.

Thanks
Amitava.
  • 1. Re: Error while doing datapump import
    EdStevens Guru
    Currently Being Moderated
    amitavachatterjee1975 wrote:
    Hi Gurus,

    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 11.1.0.7.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 11.1.0.7.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.

    Thanks
    Amitava.
    does 'DLDBO' have any quota on tablespace 'USERS'?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points