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
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: 21122
Registered: June 2005
Location: Croatia, Europe
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: PL/SQL tables
Next Topic: finding time of inserted record
Goto Forum:

Current Time: Thu Jun 22 15:52:35 CDT 2017

Total time taken to generate the page: 0.14224 seconds