93.You are using flat files as the data source for one of your data warehousing applications. To opt

93.You are using flat files as the data source for one of your data warehousing applications. To optimize
the application performance, you plan to move the data from the flat files to clustered tables in an Oracle
database.
While migrating the data, you want to have minimal impact on the database performance and optimize the
data load operation. Which method would you use to load data into the Oracle database?
A.Use the external table population.
B.Use the Oracle Data Pump export and import utility.
C.Use the conventional path data load of the SQL*Loader utility.
D.Use the INSERT INTO...SELECT command to load the data.
答案:C
解析:这里说的flat files,是一种包含没有相对关系结构的记录的文件。这个类型通常用来描述文字处理、其他结构字符或标记被移除了的文本,也就是
比如文本文件,或者csv文件等,这种类型的文件如果想导入数据库直接用SQL*Loader
直接在sqlplus中执行sqlldr就可以看到帮助
[oracle@wahaha3 trace]$ sqlldr


SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jul 23 17:31:24 2016


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Usage: SQLLDR keyword=value [,keyword=value,...]
....................
........省略........
....................
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值