Mixing
How to force SQL developer to use imp/exp command while import/export
While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp command, and for that i need to force SQL developer to use imp command instead of impdp command. And same for export.
Pleas help me if anyone knows how to in-force SQL developer to use imp for import instead of impdp and exp for export instead of expdp
oracle oracle-sqldeveloper oracle12c
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
add a comment |
While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp command, and for that i need to force SQL developer to use imp command instead of impdp command. And same for export.
Pleas help me if anyone knows how to in-force SQL developer to use imp for import instead of impdp and exp for export instead of expdp
oracle oracle-sqldeveloper oracle12c
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
1
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
1
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
1
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43
add a comment |
While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp command, and for that i need to force SQL developer to use imp command instead of impdp command. And same for export.
Pleas help me if anyone knows how to in-force SQL developer to use imp for import instead of impdp and exp for export instead of expdp
oracle oracle-sqldeveloper oracle12c
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp command, and for that i need to force SQL developer to use imp command instead of impdp command. And same for export.
Pleas help me if anyone knows how to in-force SQL developer to use imp for import instead of impdp and exp for export instead of expdp
oracle oracle-sqldeveloper oracle12c
oracle oracle-sqldeveloper oracle12c
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
edited Jan 13 at 10:48
DK Ansh
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
asked Jan 2 at 6:17
DK AnshDK Ansh
281216
281216
1
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
1
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
1
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43
add a comment |
1
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
1
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
1
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43
1
1
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
1
1
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
1
1
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43
add a comment |
2 Answers
2
active
oldest
votes
IMP and EXP are client side utilities like SQL Loader and SQLPlus.
The reason you can use SQL Developer with Data Pump, is because Data Pump runs in the database AND it has a PL/SQL API - with which we have built a GUI for in our DBA Panel.
If you need to use IMP and EXP - you need to get an Oracle Client of your machine, and install it.
You don't say which version of Oracle Database you'll be working with - that's important. Make sure the client you install will be compatible with the source database you want to generate an EXP dmp with.
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
add a comment |
You can't do this because there is no PL/Sql API for imp and exp. Oracle have only provided PL/Sql api for expdp and impdp, So SQL developer can only implement those API.
add a comment |
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
});
}
});
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%2f54002033%2fhow-to-force-sql-developer-to-use-imp-exp-command-while-import-export%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
IMP and EXP are client side utilities like SQL Loader and SQLPlus.
The reason you can use SQL Developer with Data Pump, is because Data Pump runs in the database AND it has a PL/SQL API - with which we have built a GUI for in our DBA Panel.
If you need to use IMP and EXP - you need to get an Oracle Client of your machine, and install it.
You don't say which version of Oracle Database you'll be working with - that's important. Make sure the client you install will be compatible with the source database you want to generate an EXP dmp with.
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
add a comment |
IMP and EXP are client side utilities like SQL Loader and SQLPlus.
The reason you can use SQL Developer with Data Pump, is because Data Pump runs in the database AND it has a PL/SQL API - with which we have built a GUI for in our DBA Panel.
If you need to use IMP and EXP - you need to get an Oracle Client of your machine, and install it.
You don't say which version of Oracle Database you'll be working with - that's important. Make sure the client you install will be compatible with the source database you want to generate an EXP dmp with.
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
add a comment |
IMP and EXP are client side utilities like SQL Loader and SQLPlus.
The reason you can use SQL Developer with Data Pump, is because Data Pump runs in the database AND it has a PL/SQL API - with which we have built a GUI for in our DBA Panel.
If you need to use IMP and EXP - you need to get an Oracle Client of your machine, and install it.
You don't say which version of Oracle Database you'll be working with - that's important. Make sure the client you install will be compatible with the source database you want to generate an EXP dmp with.
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
IMP and EXP are client side utilities like SQL Loader and SQLPlus.
The reason you can use SQL Developer with Data Pump, is because Data Pump runs in the database AND it has a PL/SQL API - with which we have built a GUI for in our DBA Panel.
If you need to use IMP and EXP - you need to get an Oracle Client of your machine, and install it.
You don't say which version of Oracle Database you'll be working with - that's important. Make sure the client you install will be compatible with the source database you want to generate an EXP dmp with.
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
answered Jan 2 at 13:03
thatjeffsmiththatjeffsmith
8,06211445
8,06211445
add a comment |
add a comment |
You can't do this because there is no PL/Sql API for imp and exp. Oracle have only provided PL/Sql api for expdp and impdp, So SQL developer can only implement those API.
add a comment |
You can't do this because there is no PL/Sql API for imp and exp. Oracle have only provided PL/Sql api for expdp and impdp, So SQL developer can only implement those API.
add a comment |
You can't do this because there is no PL/Sql API for imp and exp. Oracle have only provided PL/Sql api for expdp and impdp, So SQL developer can only implement those API.
You can't do this because there is no PL/Sql API for imp and exp. Oracle have only provided PL/Sql api for expdp and impdp, So SQL developer can only implement those API.
answered Jan 12 at 19:21
user10905740
add a comment |
add a comment |
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.
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%2f54002033%2fhow-to-force-sql-developer-to-use-imp-exp-command-while-import-export%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
There is no way. exp/imp do not have PL/SQL APIs.
– ibre5041
Jan 2 at 7:33
1
Why are you trying to force SQL Developer to do that instead of using the command-line tools directly?
– Alex Poole
Jan 2 at 12:19
1
Because We don't have execute access on those commands. That's why we are not able to executes these commands using command- line
– DK Ansh
Jan 3 at 5:43