Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I get index's definition for a table?

How can I get index's definition for a table?

From: PHIL <PHIL_SHEU_at_AMAX.COM>
Date: 2000/07/03
Message-ID: <pI885.27027$NP5.785700@newsread2.prod.itd.earthlink.net>#1/1 






Hi,



How can I get index definition for a table.
for example, I need information that my program generate following
statement,



CREATE UNIQUE INDEX sysadm.ps_a8_shortage
  ON sysadm.ps_a8_shortage


(


business_unit,


demand_source,


...


demand_line_no)



TABLESPACE psindex



Thanks



Phil
Received on Mon Jul 03 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US