Oracle-L: RE: Create index script in pl/sql

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 05 Jun 2003 05:54:50 -0800
Message-ID: <F001.005AADCA.20030605055450@fatcity.com>

Begin
EXECUTE IMMEDIATE '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 )';
EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, ARTNR) TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCREASE )';
End;
/

Better of, RTFM on dynamic sql using "native dynamic sql" or DBMS_SQL.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
roland.skoldblom_at_ica.se
Sent: Thursday, June 05, 2003 5:55 AM
To: Multiple recipients of list ORACLE-L

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).

--

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

Author: Igor Neyman
INET: ineyman_at_perceptron.com

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