Solved

can CONTENT=DATA_ONLY be used in DBMS_DATAPUMP and how?

Posted on 2009-04-14
5
1,758 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 73

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 73

Assisted Solution

by:sdstuber
sdstuber earned 500 total points
ID: 24140730
0
 
LVL 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now