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?

Report message to a moderator

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.

Report message to a moderator

Previous Topic: inserting
Next Topic: INTO clause error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 10:47:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.