Interview Question

Oracle Database Administrator Interview New York, NY

External tables. Can they have indexes


Interview Answer

2 Answers


I said yes. Though I mentioned that I hadn't worked with external tables extensively

Interview Candidate on Jun 11, 2013

External Tables doesn't reside in the database and you can select, join or sort external table data and also you can create views and synonyms on it but you can neither perform DML operations nor you can have indexes for EXTERNAL TABLES.

Sunney on Aug 28, 2013

Add Answers or Comments

To comment on this, Sign In or Sign Up.