|
-
MAYBE YOU MUST REMOVE ONE 'E' FROM SECOND INDEX...
EXECUTE IMMEDIATE 'CREATE BITMAPE INDEX zi2 on z_tst(c2)';
set serveroutput on
begin
begin
EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi1 on z_tst(c1)';
exception when others then
dbms_output.put_line('blabla1');
end;
begin
EXECUTE IMMEDIATE 'CREATE BITMAPE INDEX zi2 on z_tst(c2)';
exception when others then
dbms_output.put_line('blabla2');
end;
begin
EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi3 on z_tst(c3)';
exception when others then
dbms_output.put_line('blabla3');
end;
end;
Last edited by andrejm; 05-14-2003 at 04:18 AM.
Andrej
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|