User SCOTT wants to export his objects using Oracle Data Pump and executes the following
command:
$ expdp scott/tiger
directory = EXPORT_DIR
dumpfile = scott.dmp
include = table
include = view:”like ‘%DEPARTMENTS%'”
content = DATA_ONLY
Which task would the command accomplish?
A.
Oracle Data Pump would export only the data of all of the tables and views.
B.
Oracle Data Pump would export all of the table structures along with data and all the views.
C.
Oracle Data Pump would export the table data and the view definitions where the view name
contains a string named DEPARTMENTS.
D.
Oracle Data Pump would export the table data and the view definitions with data where view
name contains a string named DEPARTMENTS.
E.
Oracle Data Pump would export all of the table structures and the view definitions with data
where view name contains a string named DEPARTMENTS.
Export data in the table and view definition contains the DEPARTMENTS.
* DATA_ONLY loads only table row data into existing tables; no database objects are created.
It show data_only it does not seem to be used simultaneously with include = view, and is better to use it with include = table
http://blog.itpub.net/24131851/viewspace-678073/