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

Home -> Community -> Usenet -> c.d.o.misc -> Create index via ALTER TABLE command

Create index via ALTER TABLE command

From: Jens Riedel <JensRie_at_gmx.de>
Date: Thu, 23 Jun 2005 10:59:17 +0200
Message-ID: <3hvbv6FisraoU1@individual.net> 





Hello,



I'm just trying to move an application from MySQL to Oracle 9.2.



Now I'm looking for the equivalent for the MySQL statement:



ALTER TABLE tablename


ADD INDEX indexname ( column1, column2 )



Is there a possibility to use an ALTER TABLE syntax in Oracle, too?
I only found a CREATE INDEX statement.



Regards,


Jens
Received on Thu Jun 23 2005 - 03:59:17 CDT












Original text of this message













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