Oracle impdp only imports one schema from a dump into which expdp exported many schemas












0















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










share|improve this question

























  • 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
    6 mins ago











  • You should not use '/ as sysdba' for an export.

    – miracle173
    5 mins ago
















0















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










share|improve this question

























  • 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
    6 mins ago











  • You should not use '/ as sysdba' for an export.

    – miracle173
    5 mins ago














0












0








0








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










share|improve this question
















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







oracle-12c impdp datapump expdp






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 9 mins ago









miracle173

6,5261837




6,5261837










asked 6 hours ago









miguel ramiresmiguel ramires

133




133













  • 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
    6 mins ago











  • You should not use '/ as sysdba' for an export.

    – miracle173
    5 mins ago



















  • 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
    6 mins ago











  • You should not use '/ as sysdba' for an export.

    – miracle173
    5 mins ago

















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
6 mins ago





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
6 mins ago













You should not use '/ as sysdba' for an export.

– miracle173
5 mins ago





You should not use '/ as sysdba' for an export.

– miracle173
5 mins ago










0






active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229325%2foracle-impdp-only-imports-one-schema-from-a-dump-into-which-expdp-exported-many%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Database Administrators Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229325%2foracle-impdp-only-imports-one-schema-from-a-dump-into-which-expdp-exported-many%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Liste der Baudenkmale in Friedland (Mecklenburg)

Single-Malt-Whisky

Czorneboh