Hi,<br>after the file patching i got :<br><br>SQL> @/usr/lib/oracle/xe/app/125-alter-index-rhnRam.sql.oracle<br>delete from rhnram X<br> *<br>ERROR at line 1:<br>ORA-00942: table or view does not exist<br><br>
<br>DROP INDEX rhn_ram_sid_idx<br> *<br>ERROR at line 1:<br>ORA-01418: specified index does not exist<br><br><br> TABLESPACE [[4m_tbs]]<br> *<br>ERROR at line 3:<br>ORA-02216: tablespace name expected<br>
<br><br><br>any hints? :)<br><br><div class="gmail_quote">On Wed, May 30, 2012 at 11:53 AM, stefano ciavarella <span dir="ltr"><<a href="mailto:stefano.ciavarella@gmail.com" target="_blank">stefano.ciavarella@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'll try in a bit ;) <br><br>thanks again Jan !!! <br>Regards<div class="HOEnZb"><div class="h5"><br><br><br><div class="gmail_quote">
On Wed, May 30, 2012 at 10:06 AM, Jan Pazdziora <span dir="ltr"><<a href="mailto:jpazdziora@redhat.com" target="_blank">jpazdziora@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On Tue, May 29, 2012 at 06:09:47PM +0200, stefano ciavarella wrote:<br>
> 'SPACEWALK-SCHEMA-1.5-TO-SPACEWALK-SCHEMA-1.6/125-ALTER-INDEX-RHNRAM.SQL.ORACL<br>
> ------------------------------------------------------------------------------<br>
> spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle<br>
><br>
><br>
> Index dropped.<br>
><br>
> ON rhnRam (server_id)<br>
> *<br>
> ERROR at line 2:<br>
> ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found<br>
><br>
><br>
> this is the error into spacewalk-schema-1.7.log<br>
<br>
</div>You may want to patch your spacewalk-schema-1.5-to-spacewalk-schema-1.6<br>
directory with<br>
<br>
<a href="http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=40cbd633a357c572170f893f6f854f7f17fd3e02" target="_blank">http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=40cbd633a357c572170f893f6f854f7f17fd3e02</a><br>
<br>
and then restore your database from backup and rerun the schema<br>
upgrade.<br>
<div><div><br>
--<br>
Jan Pazdziora<br>
Principal Software Engineer, Satellite Engineering, Red Hat<br>
<br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br>Stefano Ciavarella<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>Stefano Ciavarella<br>