RE: desc indexes howto

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 3 Jul 2013 08:49:31 -0400
Message-ID: <018601ce77eb$c408e420$4c1aac60$_at_rsiz.com>

For describing indexes I prefer

select i.owner,

   decode(i.table_owner,i.owner,' ','*') X,    i.table_name,
   substr(i.table_type,1,2) TT,
   i.index_name,
   substr(i.index_type,1,2) IT,
   substr(i.uniqueness,1,1) U,
   i.blevel,

   ic.column_name,
   ic.column_position,
   ic.descend

from dba_indexes i,dba_ind_columns ic

where i.table_owner = '&table_owner'
  and i.table_name in (&table_list)
  and i.owner       = ic.index_owner
  and i.index_name  = ic.index_name
  and i.table_owner = ic.table_owner
  and i.table_name  = ic.table_name

order by i.owner,i.table_name,i.index_name,ic.column_position

unless I'm looking for something else specific. The &table_list bit of the where clause is easily dropped if you're looking at an entire schema, likewise &table_owner
if all schemas. Upper case is up to the user to enter on purpose, as are the surrounding ' marks and internal commas in the table_list.

DBA_CONSTRAINTS has the information on constraints.

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jose Soares
Sent: Wednesday, July 03, 2013 3:15 AM
To: oracle-l_at_freelists.org
Subject: desc indexes howto

Hi all,

How can I have indexes/constraints info?

I tried to delete a row from a table in my db and I got this message:

(IntegrityError) ORA-02292: integrity constraint (SFERA.SYS_C0057216) violated - child record found

I can't realize what SYS_C0057216 is and to what it is linked. I would like to know how to have information about it. Is there a way to do that?

thanks for any help.
j

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 03 2013 - 14:49:31 CEST