OraFAQ Forum: Server Administration

Wed, 02 July 2003 13:59

sidd
Messages: 130
Registered: May 2003

Senior Member

How will i know if a table got indexes on it or not

Wed, 02 July 2003 14:35

ctg
Messages: 146
Registered: July 2002

Senior Member

select index_name, column_name
from all_ind_columns
where table_name = 'YOUR_TABLE';

Thu, 03 July 2003 06:45

sidd
Messages: 130
Registered: May 2003

Senior Member

Thanks dude

Previous Topic:	v$parameter values
Next Topic:	how to change 9i spfile back to pfile??

Goto Forum:

]

Current Time: Fri Sep 20 04:21:03 CDT 2024