Oracle 18c how import .dmp file with impdpGet list of all tables in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?How do I include a JavaScript file in another JavaScript file?In Node.js, how do I “include” functions from my other files?How do I import an SQL file using the command line in MySQL?write command log to file in windowORA error when using expdpVARCHAR2 field and NVARCHAR2 exsit in the same table,the former is correct,the latter was garbledOracle 12c IMPDP errors"How to recover a schema dropped after EXPDP without doing the impdp?
Character is called by their first initial. How do I write it?
Why did NASA use U.S customary units?
Which creatures count as green creatures?
Can two figures have the same area, perimeter, and same number of segments have different shape?
What is the meaning of "you has the wind of me"?
Can GPL and BSD licensed applications be used for government work?
Grid/table with lots of buttons
What exactly makes a General Products hull nearly indestructible?
Character Frequency in a String
Keeping an "hot eyeball planet" wet
A planet illuminated by a black hole?
How to write a sincerely religious protagonist without preaching or affirming or judging their worldview?
What do teaching faculty do during semester breaks?
Why are so many countries still in the Commonwealth?
Would it be a good idea to memorize relative interval positions on guitar?
How can I receive packages while in France?
Do Rabbis get punished in Heaven for wrong interpretations or claims?
Are glider winch launches rarer in the USA than in the rest of the world? Why?
How do campaign rallies gain candidates votes?
Terence Tao - type books in other fields?
Company messed up with patent and now a lawyer is coming after me
Where is this photo of a group of hikers taken? Is it really in the Ural?
Why is a dedicated QA team member necessary?
How can I create a shape in Illustrator which follows a path in descending order size?
Oracle 18c how import .dmp file with impdp
Get list of all tables in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?How do I include a JavaScript file in another JavaScript file?In Node.js, how do I “include” functions from my other files?How do I import an SQL file using the command line in MySQL?write command log to file in windowORA error when using expdpVARCHAR2 field and NVARCHAR2 exsit in the same table,the former is correct,the latter was garbledOracle 12c IMPDP errors"How to recover a schema dropped after EXPDP without doing the impdp?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
0
I have a *.dmp file from a 3rd party partner who provides the data to work with. I want to import this into my local Oracle 18c database for a first round testing, as I'm quite new with Oracle databases.
They've also provided two long 'create table....' commands in a text file, so I reckon this dump file has data from 2 tables.
EDIT:
Using impdp following Alex Poole's suggestion, I'm getting the following errors:
C:Usersmyusername>impdp dumpfile=testdumpfile.dmp
Import: Release 18.0.0.0.0 - Production on Tue Mar 26 18:18:18 2019
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Username: c##myusername
Password:
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 2082
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2062
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2055
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4499
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1
oracle import oracle12c oracle18c
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
|
show 5 more comments
0
I have a *.dmp file from a 3rd party partner who provides the data to work with. I want to import this into my local Oracle 18c database for a first round testing, as I'm quite new with Oracle databases.
They've also provided two long 'create table....' commands in a text file, so I reckon this dump file has data from 2 tables.
EDIT:
Using impdp following Alex Poole's suggestion, I'm getting the following errors:
C:Usersmyusername>impdp dumpfile=testdumpfile.dmp
Import: Release 18.0.0.0.0 - Production on Tue Mar 26 18:18:18 2019
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Username: c##myusername
Password:
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 2082
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2062
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2055
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4499
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1
oracle import oracle12c oracle18c
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
1
Are you sure the file was created with legacyexp, rather than the more sensible data pumpexpdp? The separate table creation commands are a bit odd though. If it is a data pump file then you needimpdprather thanimp. It might be useful to know the full export command used.
– Alex Poole
Mar 26 at 16:38
@AlexPoole I've edited the question.impdpexists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.
– MattSom
Mar 26 at 16:47
1
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and callimpdp.exeexplicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with theimpversion I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).
– Alex Poole
Mar 26 at 16:50
@AlexPoole I've submitted the images, becauseimpandimpdpwindows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference betweenimpandimpdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.
– MattSom
Mar 26 at 16:57
1
See the docs I already linked to for information about runningimpdp.expwas desupported in 11g and that and its sisterimpshould be very rarely used now. If you runimporimpdpfrom a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.
– Alex Poole
Mar 26 at 17:01
|
show 5 more comments
0
0
0
I have a *.dmp file from a 3rd party partner who provides the data to work with. I want to import this into my local Oracle 18c database for a first round testing, as I'm quite new with Oracle databases.
They've also provided two long 'create table....' commands in a text file, so I reckon this dump file has data from 2 tables.
EDIT:
Using impdp following Alex Poole's suggestion, I'm getting the following errors:
C:Usersmyusername>impdp dumpfile=testdumpfile.dmp
Import: Release 18.0.0.0.0 - Production on Tue Mar 26 18:18:18 2019
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Username: c##myusername
Password:
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 2082
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2062
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2055
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4499
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1
oracle import oracle12c oracle18c
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
I have a *.dmp file from a 3rd party partner who provides the data to work with. I want to import this into my local Oracle 18c database for a first round testing, as I'm quite new with Oracle databases.
They've also provided two long 'create table....' commands in a text file, so I reckon this dump file has data from 2 tables.
EDIT:
Using impdp following Alex Poole's suggestion, I'm getting the following errors:
C:Usersmyusername>impdp dumpfile=testdumpfile.dmp
Import: Release 18.0.0.0.0 - Production on Tue Mar 26 18:18:18 2019
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Username: c##myusername
Password:
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 2082
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2062
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2055
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4499
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1
oracle import oracle12c oracle18c
oracle import oracle12c oracle18c
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
edited Mar 26 at 17:24
MattSom
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
asked Mar 26 at 16:08
MattSomMattSom
4781 gold badge10 silver badges25 bronze badges
4781 gold badge10 silver badges25 bronze badges
1
Are you sure the file was created with legacyexp, rather than the more sensible data pumpexpdp? The separate table creation commands are a bit odd though. If it is a data pump file then you needimpdprather thanimp. It might be useful to know the full export command used.
– Alex Poole
Mar 26 at 16:38
@AlexPoole I've edited the question.impdpexists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.
– MattSom
Mar 26 at 16:47
1
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and callimpdp.exeexplicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with theimpversion I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).
– Alex Poole
Mar 26 at 16:50
@AlexPoole I've submitted the images, becauseimpandimpdpwindows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference betweenimpandimpdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.
– MattSom
Mar 26 at 16:57
1
See the docs I already linked to for information about runningimpdp.expwas desupported in 11g and that and its sisterimpshould be very rarely used now. If you runimporimpdpfrom a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.
– Alex Poole
Mar 26 at 17:01
|
show 5 more comments
1
Are you sure the file was created with legacyexp, rather than the more sensible data pumpexpdp? The separate table creation commands are a bit odd though. If it is a data pump file then you needimpdprather thanimp. It might be useful to know the full export command used.
– Alex Poole
Mar 26 at 16:38
@AlexPoole I've edited the question.impdpexists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.
– MattSom
Mar 26 at 16:47
1
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and callimpdp.exeexplicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with theimpversion I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).
– Alex Poole
Mar 26 at 16:50
@AlexPoole I've submitted the images, becauseimpandimpdpwindows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference betweenimpandimpdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.
– MattSom
Mar 26 at 16:57
1
See the docs I already linked to for information about runningimpdp.expwas desupported in 11g and that and its sisterimpshould be very rarely used now. If you runimporimpdpfrom a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.
– Alex Poole
Mar 26 at 17:01
1
1
Are you sure the file was created with legacy
exp, rather than the more sensible data pump expdp? The separate table creation commands are a bit odd though. If it is a data pump file then you need impdp rather than imp. It might be useful to know the full export command used.– Alex Poole
Mar 26 at 16:38
Are you sure the file was created with legacy
exp, rather than the more sensible data pump expdp? The separate table creation commands are a bit odd though. If it is a data pump file then you need impdp rather than imp. It might be useful to know the full export command used.– Alex Poole
Mar 26 at 16:38
@AlexPoole I've edited the question.
impdp exists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.– MattSom
Mar 26 at 16:47
@AlexPoole I've edited the question.
impdp exists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.– MattSom
Mar 26 at 16:47
1
1
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and call
impdp.exe explicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with the imp version I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).– Alex Poole
Mar 26 at 16:50
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and call
impdp.exe explicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with the imp version I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).– Alex Poole
Mar 26 at 16:50
@AlexPoole I've submitted the images, because
imp and impdp windows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference between imp and impdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.– MattSom
Mar 26 at 16:57
@AlexPoole I've submitted the images, because
imp and impdp windows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference between imp and impdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.– MattSom
Mar 26 at 16:57
1
1
See the docs I already linked to for information about running
impdp. exp was desupported in 11g and that and its sister imp should be very rarely used now. If you run imp or impdp from a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.– Alex Poole
Mar 26 at 17:01
See the docs I already linked to for information about running
impdp. exp was desupported in 11g and that and its sister imp should be very rarely used now. If you run imp or impdp from a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.– Alex Poole
Mar 26 at 17:01
|
show 5 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
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%2fstackoverflow.com%2fquestions%2f55361599%2foracle-18c-how-import-dmp-file-with-impdp%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
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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
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%2fstackoverflow.com%2fquestions%2f55361599%2foracle-18c-how-import-dmp-file-with-impdp%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
1
Are you sure the file was created with legacy
exp, rather than the more sensible data pumpexpdp? The separate table creation commands are a bit odd though. If it is a data pump file then you needimpdprather thanimp. It might be useful to know the full export command used.– Alex Poole
Mar 26 at 16:38
@AlexPoole I've edited the question.
impdpexists instantly as well. I've managet to take a quick snapshot, it is looking for an expdat.dmp. There is no such a file of course.– MattSom
Mar 26 at 16:47
1
Please post text rather than images. We can't see how you're running it. It would be easier for us and for you if you open a command window and call
impdp.exeexplicitly from that, with appropriate arguments, particularly the file name (just the name not the full path). See the docs. If you do that with theimpversion I suspect you'd see an error like 'IMP-00038' indicating the dump file isn't recognised (hopefully because it is a data pump file).– Alex Poole
Mar 26 at 16:50
@AlexPoole I've submitted the images, because
impandimpdpwindows shut down without any error messages instantly, so I can't even see them without taking a snapshot. To be honest I don't know the difference betweenimpandimpdp. I've just got this dump file today to import it into our Oracle database and I'm trying to make sense out of it. I'm trying now with SQL Developer, but I'm also not sure whether the Data Pump function there is good for external .dmp files.– MattSom
Mar 26 at 16:57
1
See the docs I already linked to for information about running
impdp.expwas desupported in 11g and that and its sisterimpshould be very rarely used now. If you runimporimpdpfrom a command (aka DOS) window then you can supply arguments, that window won't disappear after an error, you'll be able to see what you're running and what happens, and you'll be able to copy text from that instead of having to try to capture an image.– Alex Poole
Mar 26 at 17:01