4 Replies Latest reply: Oct 12, 2012 4:27 AM by user85991 RSS

    impdp work with system but doesn't work with another user


      We have troubles with import of transportable tablespace, when i try to import it with system the import is done currectly, when i try to use another user we receive this message :

      impdp bmcese/***** directory=TTS_DIR dumpfile=RMCCO_RMC_ANA_STS_ABB_CO121001.dmp TRANSPORT_DATAFILES=/data/TTS/RMCCO_RMC_ANA_STS_ABB_CO121001.dbf logfile=tts_imp_proc.log

      ORA-31626: il job non esiste
      ORA-31633: impossibile creare la tabella principale "BMCESE.SYS_IMPORT_TRANSPORTABLE_05"
      ORA-06512: a "SYS.DBMS_SYS_ERROR", line 95
      ORA-06512: a "SYS.KUPV$FT", line 1020
      ORA-00959: tablespace 'RMCCO_RMC_UTZ_PP080531' inesistente

      this happens only on development server and it work into test server, so i don't think that the problem is in grants(i controlled that are the same and i have tried with DBA grant too and we received the error).
      Another strange thing is that tablespace 'RMCCO_RMC_UTZ_PP080531' is not included into the dump that i try to import and it doesn't exist in the database.


      Edited by: user11272630 on 10-ott-2012 8.40