<html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Is it just this relation? If yes, try to create a new one from the psql interpreter. For that, login to psql with spaceuser and password of spaceuser and do a CREATE TABLE log; Mind the semicolon, it's important. After that, try importing the oracle dump again. Regards, Daniel Am 07.01.2014 09:53, schrieb Željko Dokman: </div> <blockquote cite="mid:DC0008817123784992EB40D773A48BA845AF85@MBUDAG1.mbu.local" type="cite"> <pre wrap="">Please can so body help me, my database knowledge is quite poor, so this error is a show stopper for my oracle>postgres migration Best regards -----Original Message----- From: <a class="moz-txt-link-abbreviated" href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a class="moz-txt-link-freetext" href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Milan Zázrivec Sent: Friday, January 03, 2014 5:03 PM To: <a class="moz-txt-link-abbreviated" href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] OracleXE to Postgresql mig problem On Friday 03 January 2014 15:55:01 Željko Dokman wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi all I need some help with migrating my spacewalk backend DB from Oracle XE to PostgreSQL. I am following instructions from <a class="moz-txt-link-freetext" href="https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle">https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle</a> And everything was going OK until the point where Oracle dump is to be imported in to postgresql. [root@skynet ~]# PGPASSWORD=******* psql -h localhost -U spaceuser spaceschema < /tmp/spacewalk-oracle.dump UPDATE 0 ERROR: relation "log" does not exist Can anyone help me to resolve this problem? </pre> </blockquote> <pre wrap=""> Has your PostgreSQL schema been properly populated? Do your Oracle and PostgreSQL schema versions match? -MZ _______________________________________________ Spacewalk-list mailing list <a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </pre> <fieldset class="mimeAttachmentHeader"></fieldset> <pre wrap="">_______________________________________________ Spacewalk-list mailing list <a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre> </blockquote> <pre class="moz-signature" cols="72">-- ---------------------------------------------------------------- Daniel Souvignier Fachinformatiker Systemintegration in Ausbildung Lehrstuhl für integrierte Analogschaltungen RWTH Aachen Sommerfeldstraße 24 (Walther-Schottky-Haus) 52074 Aachen Raum 24C 313 Tel.:0241/80-27771 <a class="moz-txt-link-abbreviated" href="http://www.ias.rwth-aachen.de">www.ias.rwth-aachen.de</a> </pre> </body> </html>