Re: Help need

Hi deewakar,
 
hope this will help..
 
SELECT
TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXES<FONT color=#0000ff face=Arial size=2>ORDER BY 1,2,3/  
Saurabh Sharma
Oracle DBA
saurabh00pc_at_yahoo.com<A
href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html <BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Deewaker G.V. To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Friday, July 27, 2001 2:20 PM Subject: Help need

  HI DBA Guru's
  I wanted to know all the Index
  names under respective table spaces
  For example
  Tablespace is Production
        <FONT color=#0000ff

  face="Arial Narrow">Table name : customer, item, supplier <FONT   color=#0000ff
  face="Arial Narrow">           
  index Names  idx_customer_custid
       
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_customer_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_name        
  Tablespace is Quality
        <FONT color=#0000ff

  face="Arial Narrow">Table name : customer, item, supplier <FONT   color=#0000ff
  face="Arial Narrow">           
  index Names  idx_customer_custid
       
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_customer_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_name
  Tablespace is Development
        <FONT color=#0000ff

  face="Arial Narrow">Table name : customer, item, supplier <FONT   color=#0000ff
  face="Arial Narrow">           
  index Names  idx_customer_custid
       
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_customer_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_item_name        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_itemid        
        <FONT color=#0000ff

  face="Arial Narrow">         
  idx_supplier_name
  with warm regards,
  Deewaker G. V.
  Baazee.com India Pvt. Ltd.
  (<FONT color=#0000ff

  face="Book Antiqua">: 4611323 Extn: 216 <FONT color=#0000ff 
  face="Book Antiqua">Fax : 4611324 
  <<Deewaker G.V..vcf>>