1 Reply Latest reply: Jan 7, 2013 2:06 PM by amitavachatterjee1975 RSS

    Error while doing datapump import

    amitavachatterjee1975
      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
          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'?