[每日一题] OCP1z0-047 :2013-07-27外部表??不能被DML和建索引(二)
- ---------- ---------- ---------- ---------- ----------
6 6 6 6 6 600
7 7 7 7 7 700
gyj@OCM> create synonym s_cost for ext_gyj_costs;
Synonym created.
gyj@OCM> select * from s_cost;
CHANNEL_ID PROD_ID PROMO_ID TIME_ID UNIT_COST UNIT_PRICE
---------- ---------- ---------- ---------- ---------- ----------
6 6 6 6 6 600
7 7 7 7 7 700
4、 对外部表建索引，不支操作
[html]
gyj@OCM> create index idx_chaannel_id on ext_gyj_costs(channel_id);
create index idx_chaannel_id on ext_gyj_costs(channel_id)
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
总结：外部表除了可以select(查询)、建视图，同义词，其它操作如DML,建索引等都不支持。
正确答案：C