Home » SQL & PL/SQL » SQL & PL/SQL » On External Table
On External Table [message #187469] Mon, 14 August 2006 02:45 Go to next message
Messages: 27
Registered: July 2005
Junior Member
Is it possible to create index on external table?

Re: On External Table [message #187473 is a reply to message #187469] Mon, 14 August 2006 02:51 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member

Think about it - Oracle has no control over the contents of the file the table is based on, and no way of knowing if or when it is changed. Any index could be invalid 5 minutes after it was created and there'd be no way of knowing.
Previous Topic: inserting
Next Topic: INTO clause error
Goto Forum:

Current Time: Sun Jul 23 01:51:46 CDT 2017

Total time taken to generate the page: 0.04076 seconds