| Oracle Virtual Indexes [message #64254] |
Thu, 06 January 2005 02:37  |
arun
Messages: 67
Registered: January 2000
|
Member |
|
|
Can u kindly help me wrt following questions about Oracle Virtual Indexes
What versions is this feature available in ?
Are there any init.ora or other pre-requisites required to do this ? Any system permissions required to do this ?
Can you simply issue the same DROP INDEX command to remove it ?
|
|
|
|
|
|
| Re: Oracle Virtual Indexes [message #64256 is a reply to message #64254] |
Thu, 06 January 2005 03:28  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
> What versions is this feature available in?
The Virtual Indexes feature is available in 8i (at least in 8.1.7) and above of the Oracle server. It is definitely not available on 8.0.6 and below.
> Are there any init.ora or other pre-requisites required to do this? Any system permissions required to do this?
None, except the usual to create and drop indexes. However, you need to set "_USE_NOSEGMENT_INDEXES" before your session will recognize them.
SQL> ALTER SESSION SET "_use_nosegment_indexes" = TRUE;
Session altered.
> Can you simply issue the same DROP INDEX command to remove it?
Yes, here is an example:
SQL> CREATE INDEX emp_vi1 ON emp(hiredate) NOSEGMENT;
Index created.
SQL> DROP INDEX emp_vi1;
Index dropped.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
