Oracle Indexes 1

[fugarte]

The following statement lists all indexes in the database:

select * from ALL_INDEXES

Is there a way to get the properties of a particular index vis SQL-PLUS. Basically I am looking for the create index statement to see the fields used in a particular index.

 

[ThomVF]

select index_name, column_name, column_position
from user_ind_columns
order by index_name, column_position;


This shows the column in the index and their order.
You could also do this against ALL_IND_COLUMNS
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[fmorel]

Thank you for answers.

spool does not seem to change default directory. (spool is output, and I want to change "input" directory)

In fact, I am looking for a command to change default dir.

 

[slaing]

I guess you mean that you want SQL*Plus to find files without having to type in the full filespec.

On Windows platforms you can do it via the registry. Use HKLM->Software->Oracle->{oracle home id}->SQLPATH key to define a search path of directories (sep. by semi-colons)

eg c:\oracle\ORA8i\DBS;c:\user\me\sql

I guess on Unix you could set an environment variable to do the same (I'm sure a Unix user will be able to confirm/deny that)

HTH

Steve Laing

 

[fmorel]

OOOPS
I am sorry, my post did not go in the correct thread...

Thanks Steve, you answered my question from the other thread !!!