Oracle impdp only imports one schema from a dump into which expdp exported many schemas
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
edited 9 mins ago
miracle173
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
133
add a comment |
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
edited 9 mins ago
miracle173
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
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
add a comment |
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
edited 9 mins ago
miracle173
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
133
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
oracle-12c impdp datapump expdp
edited 9 mins ago
miracle173
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
133
edited 9 mins ago
miracle173
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
133
edited 9 mins ago
miracle173
6,5261837
edited 9 mins ago
miracle173
6,5261837
edited 9 mins ago
miracle173
6,5261837
6,5261837
asked 6 hours ago
miguel ramiresmiguel ramires
133
asked 6 hours ago
miguel ramiresmiguel ramires
133
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
add a comment |
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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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