Hi

you can try with the

select * from user_indexes where INDEX_NAME = '<INDEX_NAME>' ;

OR to find contraints index

select * from user_constraints where constraint_name='name of constraint'

Regards
Rahul Chaudhari

----- Original Message -----
From: "RABaltazar" <oracledba-ezmlmshield-x89961534.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 31, 2005 3:26 PM
Subject: RE: Truncating Table related to other table


>
> Hi to all, im new to Oracle, im trying to truncate a table, but the
database wouldn't allow since the table has other index related to other
table. I think ineed to delete those rows on the said table(s) fisrt but HOW
CAN I KNOW WHICH TABLE(s). How to find out?
>
> Thanks,
>
>
> __________________________________________________
> This communication is intended solely for the use of the addressee and
authorized recipients. It may contain confidential or legally privileged
information and is subject to the conditions in
http://www.smart.com.ph/disclaimer.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page