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 DPARTMENTS.
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.大家看看吧,顺便在ORACLE服务器上调试一下.
$ 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 DPARTMENTS.
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.大家看看吧,顺便在ORACLE服务器上调试一下.
解决方案 »
- 求指教这个SQL怎么写
- 全关系系统的十二条基本准则讨论
- [安装]一个非常详细的Oracle10.2在Red Hat Linux4 上的安装文档
- 关于大数据表优化德问题(每张表的数据量千万级)
- TOAD表数据倒入的问题?
- 在ORACLE中,如何切换数据库,请教高人指点。
- 急~~~ Oracle数据库的同步问题。
- 2003下装92010NT_Disk1的setup.exe出现【错误】,安装日值中提示,如下:
- connect sys/change_on_install@testdb as sysdba 报错:insufficient priviledges ?
- 我连接到Oracle8i数据库出错了,不知道是那里的错误?请帮帮忙!!!
- 访问局域网oracle数据库host string的问题
- oracle读取文件的路径问题
C. Oracle Data Pump would export the table data and the view definitions where the view name contains a string named DEPARTMENTS.