schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 6333e7a98c56481f35f848c3e78f013c32ddf5a5
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Apr 29 18:26:30 2009 +0200
alter index needs to be run via execute immediate
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
index 92c576f..d04697b 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
@@ -12,7 +12,7 @@ begin
nologging';
exception
when name_used then
- alter index rhn_snc_speid_idx noparallel;
+ execute immediate 'alter index rhn_snc_speid_idx noparallel';
end;
/
Show replies by date