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
bala_id
Messages: 27
Registered: July 2005
Junior Member
Hi,
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
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Nope.

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: Sat Dec 10 05:00:30 CST 2016

Total time taken to generate the page: 0.05834 seconds