Home » SQL & PL/SQL » SQL & PL/SQL » Index
Index [message #222287] Fri, 02 March 2007 12:14 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Karma: 0
1) I have login with HR user.

I able to create table as well as index.

But when I try to create function index EG.

ON employee(UPPER(last_name));

It gives me error insufficient privileges.

I have to add REQWRITE QUERY privileges to HR user a/c.

After that I am able to create that.

Any one knows why so?

As per Oracle University Introduction to 9i: SQL
Index is physically & logically separate from table.

Physically can understand as store in different file.

But how logically?

It is totally depended on table.

Even when once delete related column or table index automatically gets deleted.
Re: Index [message #222314 is a reply to message #222287] Fri, 02 March 2007 15:27 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Karma: 0
Senior Member
Account Moderator
The index you created is a FUNCTION-BASED index. That's why.

"Logically independent" means that you can create or drop an index any time without affecting base table or other indexes; also, applications will continue to work (probably with decreased performances, but they will still work).
Previous Topic: Cast 1 as integer
Next Topic: characters and numeric count in a String
Goto Forum:

Current Time: Tue Aug 22 13:47:27 CDT 2017

Total time taken to generate the page: 0.06668 seconds