I want to do some refreshing of my tables and would like to use a package to do so but I get an error when trying to drop or create an index in the package script. Is this something that can't be done in a package? I know you can't drop a table or view in a package, but does it also apply to table indexes?
Is there another way I can script do have an index dropped and then re-created?
Here's my procedure in the package:
-- purge the table
delete from [table name];
-- drop the bitmap index
drop index [index name];
-- do insert
-- re-create bitmap index