Only select on External Tables

QUESTION

EMPDET is an external table containing the columns EMPNO and ENAME. Which command
would work in relation to the EMPDET table?
A. UPDATE empdet
SET ename = 'Amit'
WHERE empno = 1234;
B. DELETE FROM empdet
WHERE ename LIKE 'J%';
C. CREATE VIEW empvu
AS
SELECT * FROM empdept;
D. CREATE INDEX empdet_idx
ON empdet(empno);

reference :
1 You can connect to the database and create metadata for the external table using DDL. The DDL for an external table consists of two parts: one part that describes the Oracle column types, and another part (the access parameters) that describes the mapping of the external data to the Oracle data columns.

2 External tables are read only; therefore, no DML operations are possible, and no index can be created on them.

3 nonsupport LOB

4 before load you can query

5 extensive transformations on load

6 pipellininn

7 load big table

8 non temp table

9 non  physical space

……

  Only os datafile!hehe

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-718543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-718543/