I have the following problem and doubt in Oracle. I am trying to import with impdp a dump from my database into which I exported several schemes.

The problem comes when I try to import into the same database in another scheme completely empty one and only one of those schemes that are in the export (expdp). During the import show several errors of creation, of sequences, of data that already exist and of creation of other objects in general. How is this possible if the scheme where I import this empty? the expdp I execute it in the following way:

To export: 

expdp \ "/ as sysdba \" DIRECTORY=logic_bakups DUMPFILE=backup%U.dmp FLASHBACK_TIME=timestamp PARALLEL=5 SCHEMAS=SCH1,SCH2,SCH3,SCH4

To import:

impdp \ "/ as sysdba \" DIRECTORY=imp_logic_backups DUMPFILE=backup%U.dmp PARALLEL=5 REMAP_SCHEMA=SCH3:SCH3_V2 REMAP_TABLESPACE=source_tablespace:target_tablespace_V2

Thank you

  • I tried to improve the title and the first paragraph of the text. But I don't know what is the exact meaning of the second paragraph. Maybe you could improve it. – miracle173 Feb 10 '19 at 7:19
  • You should not use '/ as sysdba' for an export. – miracle173 Feb 10 '19 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.