Funny.. Wish I had this email a while back. I struggled thru the same
with rhnKSRawData with exacly the same solution..
/ apparently seems to make sense only if have a begin end;
Partha
Mike McCune wrote:
Mike McCune wrote:
Ok, so I'm trying to recreate our schema and running into odd errors
that don't make sense.
When I run:
make satellite-clean satellite-release TBS=USERS
SQLUSER=spacewalk/[EMAIL PROTECTED]
it eventually errors out with:
Index created.
create index rhn_channel_access_idx
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production
make[1]: Leaving directory `/home/mmccune/spacewalk/schema/spacewalk'
which makes no sense because looking at universe.satellite.sql I only
see the object referenced once:
$ grep rhn_channel_access_idx universe.satellite.sql
create index rhn_channel_access_idx
Is it possible the error is *NOT* rhn_channel_access_idx and is in
fact some other thing and the error reporting is wrong?
Mike
Figured it out. Realized we had some extra forward slashes in our SQL.
Only need those if you are defining a trigger:
--- a/schema/spacewalk/rhnsat/tables/rhnChannel.sql
+++ b/schema/spacewalk/rhnsat/tables/rhnChannel.sql
@@ -110,7 +110,6 @@ create index rhn_channel_access_idx
initrans 32
nologging;
-/
show errors
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
