[Spacewalk-list] spacewalk-dobby problem

[stefano ciavarella]

Hi,
after the file patching i got :

SQL> @/usr/lib/oracle/xe/app/125-alter-index-rhnRam.sql.oracle
delete from rhnram X
            *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP INDEX rhn_ram_sid_idx
           *
ERROR at line 1:
ORA-01418: specified index does not exist


    TABLESPACE [[4m_tbs]]
               *
ERROR at line 3:
ORA-02216: tablespace name expected



any hints? :)

On Wed, May 30, 2012 at 11:53 AM, stefano ciavarella <
stefano.ciavarella at gmail.com> wrote:

> I'll try in a bit ;)
>
> thanks again Jan !!!
> Regards
>
>
>
> On Wed, May 30, 2012 at 10:06 AM, Jan Pazdziora <jpazdziora at redhat.com>wrote:
>
>> On Tue, May 29, 2012 at 06:09:47PM +0200, stefano ciavarella wrote:
>> >
>> 'SPACEWALK-SCHEMA-1.5-TO-SPACEWALK-SCHEMA-1.6/125-ALTER-INDEX-RHNRAM.SQL.ORACL
>> >
>> ------------------------------------------------------------------------------
>> >
>> spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
>> >
>> >
>> > Index dropped.
>> >
>> >     ON rhnRam (server_id)
>> >        *
>> > ERROR at line 2:
>> > ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
>> >
>> >
>> > this is the error into  spacewalk-schema-1.7.log
>>
>> You may want to patch your spacewalk-schema-1.5-to-spacewalk-schema-1.6
>> directory with
>>
>>
>> http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=40cbd633a357c572170f893f6f854f7f17fd3e02
>>
>> and then restore your database from backup and rerun the schema
>> upgrade.
>>
>> --
>> Jan Pazdziora
>> Principal Software Engineer, Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
>
> --
> Stefano Ciavarella
>



-- 
Stefano Ciavarella
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120530/2dc1b810/attachment.htm>