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 -> Re: NEWBIE Question : alter index

Re: NEWBIE Question : alter index

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 18 Feb 1999 00:32:41 +0000
Message-ID: <36CB5FA9.16C8E49C@rdbms.freeserve.co.uk> 





John,



Try using DBMS_UTILITY.EXEC_DDL_STATEMENT('ALTER INDEX ...') much
quicker than setting up dbms_sql ;)



Chris.



John Alden wrote:


> 


> Can you use the ALTER INDEX command in a PL/SQL procedure


>  or do you use dbms_sql ???


> I basically want to read thru the dba_indexes to alter index info..


> Platform: Oracle 8


>                NT


> Thanks in advance.....


Received on Wed Feb 17 1999 - 18:32:41 CST












Original text of this message













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