Solved

can CONTENT=DATA_ONLY be used in DBMS_DATAPUMP and how?

Posted on 2009-04-14
5
1,899 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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 500 total points
ID: 24140730
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

736 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