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 all of the table structures along with data and all the
views.
B.
Oracle Data Pump would export all of the table structures and the view definitions with
data where view name contains a string named DEPARTMENTS.
C.
Oracle Data Pump would export only the data of all of the tables and views.
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 the table data and the view definitions where the view
name contains a string named DEPARTMENTS.
can someone please explain why E. ?
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm
DATA_ONLY unloads only table row data; no database object definitions are unloaded.
Hello,
Actually, the view included name and content which are one or more query under. So that it is name ( definition) of view will be used in the condition statement. We cannot use the content of view ( sqls) to compare in the condition statement.
Thank you
Vinh