Create index script in pl/sql

From: <roland.skoldblom_at_ica.se>
Date: Thu, 05 Jun 2003 02:54:42 -0800
Message-ID: <F001.005AAC90.20030605025442@fatcity.com>

Hallo all,

anyone whom could help me with this:

I would like to have an example of pl/sql procedur which does the following:

CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
  ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)   TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCREASE ) ;

CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON   ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, ARTNR)   TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCREASE ) So the pl/sql procedur should create those 2 indexesd, how can I write the pl/sql code then?

Thanks in advance

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: roland.skoldblom_at_ica.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 05 2003 - 05:54:42 CDT