?
Solved

can CONTENT=DATA_ONLY be used in DBMS_DATAPUMP and how?

Posted on 2009-04-14
5
Medium Priority
?
2,265 Views
Last Modified: 2013-12-18
Want to use the data pump API with option CONTENT=DATA_ONLY . How to do that?
0
Comment
Question by:jl66
  • 3
  • 2
5 Comments
 

Author Comment

by:jl66
ID: 24140486
If we use impdp utility, we can use the option content=data_only, how to do the same thing with this API
DBMS_DATAPUMP?
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 24140723
INCLUDE_METADATA parameter corresponds to the command line CONTENT option


DBMS_DATAPUMP.SET_PARAMETER (your_handle,'INCLUDE_METADATA',0);
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 2000 total points
ID: 24140730
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 2000 total points
ID: 24140739
note the TRUNCATE vs APPEND options on the TABLE_EXISTS_ACTION
0
 

Author Closing Comment

by:jl66
ID: 31570035
Excellent!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month17 days, 4 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question