Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index On External table

weekendDec 19 2005 — edited Dec 19 2005
Hi

Can I apply index on the column(s) of external table.
If yes then how?
If no then please guide me how can I achieve my following goal.

Despite deleting old data & managing growing datafiles I want that I use the read only .dat files and replace the old/outdated .dat files.
It is easily possible with external table utility but I also need indexing to enhance performance.
Can anyone help me?

Thanks
Jawad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2006
Added on Dec 19 2005
6 comments
2,266 views