Data Pump throws an errorDatapump error in log fileOracle 11g .DMP viewerOracle error: UDI-00018: Data Pump...
Why is there a voltage between the mains ground and my radiator?
What to do when during a meeting client people start to fight (even physically) with each others?
Unreachable code, but reachable with exception
Can someone explain what is being said here in color publishing in the American Mathematical Monthly?
Could you please stop shuffling the deck and play already?
Make a transparent 448*448 image
Built-In Shelves/Bookcases - IKEA vs Built
Am I not good enough for you?
Latest web browser compatible with Windows 98
The bar has been raised
How do I express some one as a black person?
Virginia employer terminated employee and wants signing bonus returned
How strictly should I take "Candidates must be local"?
Why would one plane in this picture not have gear down yet?
Space in array system equations
Placing subfig vertically
Do Bugbears' arms literally get longer when it's their turn?
Algorithm to convert a fixed-length string to the smallest possible collision-free representation?
How did Alan Turing break the enigma code using the hint given by the lady in the bar?
Examples of a statistic that is not independent of sample's distribution?
In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?
Single word request: Harming the benefactor
Word for a person who has no opinion about whether god exists
Are babies of evil humanoid species inherently evil?
Data Pump throws an error
Datapump error in log fileOracle 11g .DMP viewerOracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00Using environment variables in data pump querySpecific issue on data pump API in oracleOracle Data Pump Import imports no recordsExport Data Pump skipped packages bodiesOracle data pump export / import errorsOracle Data Pump, pause a jobOracle data pump import parallel configurationOracle 12 Startup upgrade throws error 443
I am trying to do datapump.
DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.open( operation => 'EXPORT', job_mode => 'TABLE', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'tab1.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.add_file( handle => hdnl, filename => 'exp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''USERS'')');
DBMS_DATAPUMP.METADATA_FILTER(handle => hdnl,name => 'NAME_EXPR',value => 'IN (''CA_FILE'')');
DBMS_DATAPUMP.start_job(hdnl);
END;
/
But this throws an error:
Error report -
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 5
39001. 00000 - "invalid argument value"
*Cause: The user specified API parameters were of the wrong type or
value range. Subsequent messages supplied by
DBMS_DATAPUMP.GET_STATUS will further describe the error.
*Action: Correct the bad argument and retry the API.
Please help.
oracle
asked Jan 26 '16 at 19:55
dangdang
7618
add a comment |
I am trying to do datapump.
DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.open( operation => 'EXPORT', job_mode => 'TABLE', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'tab1.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.add_file( handle => hdnl, filename => 'exp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''USERS'')');
DBMS_DATAPUMP.METADATA_FILTER(handle => hdnl,name => 'NAME_EXPR',value => 'IN (''CA_FILE'')');
DBMS_DATAPUMP.start_job(hdnl);
END;
/
But this throws an error:
Error report -
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 5
39001. 00000 - "invalid argument value"
*Cause: The user specified API parameters were of the wrong type or
value range. Subsequent messages supplied by
DBMS_DATAPUMP.GET_STATUS will further describe the error.
*Action: Correct the bad argument and retry the API.
Please help.
oracle
asked Jan 26 '16 at 19:55
dangdang
7618
add a comment |
I am trying to do datapump.
DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.open( operation => 'EXPORT', job_mode => 'TABLE', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'tab1.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.add_file( handle => hdnl, filename => 'exp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''USERS'')');
DBMS_DATAPUMP.METADATA_FILTER(handle => hdnl,name => 'NAME_EXPR',value => 'IN (''CA_FILE'')');
DBMS_DATAPUMP.start_job(hdnl);
END;
/
But this throws an error:
Error report -
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 5
39001. 00000 - "invalid argument value"
*Cause: The user specified API parameters were of the wrong type or
value range. Subsequent messages supplied by
DBMS_DATAPUMP.GET_STATUS will further describe the error.
*Action: Correct the bad argument and retry the API.
Please help.
oracle
asked Jan 26 '16 at 19:55
dangdang
7618
I am trying to do datapump.
DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.open( operation => 'EXPORT', job_mode => 'TABLE', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'tab1.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.add_file( handle => hdnl, filename => 'exp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''USERS'')');
DBMS_DATAPUMP.METADATA_FILTER(handle => hdnl,name => 'NAME_EXPR',value => 'IN (''CA_FILE'')');
DBMS_DATAPUMP.start_job(hdnl);
END;
/
But this throws an error:
Error report -
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 5
39001. 00000 - "invalid argument value"
*Cause: The user specified API parameters were of the wrong type or
value range. Subsequent messages supplied by
DBMS_DATAPUMP.GET_STATUS will further describe the error.
*Action: Correct the bad argument and retry the API.
Please help.
oracle
oracle
asked Jan 26 '16 at 19:55
dangdang
7618
asked Jan 26 '16 at 19:55
dangdang
7618
asked Jan 26 '16 at 19:55
dangdang
7618
asked Jan 26 '16 at 19:55
dangdang
7618
asked Jan 26 '16 at 19:55
dangdang
7618
7618
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You got the error from line 5. This is line 5:
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file
);
If the specified dumpfile already exists, this line throws the above error. You can add reusefile => 1 to overwrite the existing file and avoid this error.
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file,
reusefile => 1
);
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
add a comment |
I am getting this error while doing import
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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%2f127393%2fdata-pump-throws-an-error%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
You got the error from line 5. This is line 5:
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file
);
If the specified dumpfile already exists, this line throws the above error. You can add reusefile => 1 to overwrite the existing file and avoid this error.
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file,
reusefile => 1
);
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
add a comment |
You got the error from line 5. This is line 5:
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file
);
If the specified dumpfile already exists, this line throws the above error. You can add reusefile => 1 to overwrite the existing file and avoid this error.
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file,
reusefile => 1
);
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
add a comment |
You got the error from line 5. This is line 5:
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file
);
If the specified dumpfile already exists, this line throws the above error. You can add reusefile => 1 to overwrite the existing file and avoid this error.
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file,
reusefile => 1
);
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
You got the error from line 5. This is line 5:
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file
);
If the specified dumpfile already exists, this line throws the above error. You can add reusefile => 1 to overwrite the existing file and avoid this error.
DBMS_DATAPUMP.ADD_FILE(
handle => hdnl, filename => 'tab1.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file,
reusefile => 1
);
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
answered Jan 26 '16 at 20:26
Balazs PappBalazs Papp
26.6k2931
26.6k2931
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
add a comment |
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
The above was not needed, it worked automatically. I updated the question: dba.stackexchange.com/questions/127400/…
– dang
Jan 26 '16 at 20:33
add a comment |
I am getting this error while doing import
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am getting this error while doing import
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am getting this error while doing import
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am getting this error while doing import
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 5 mins ago
SrikanthSrikanth
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 5 mins ago
SrikanthSrikanth
1
answered 5 mins ago
SrikanthSrikanth
1
1
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Srikanth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
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%2f127393%2fdata-pump-throws-an-error%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
