Re: [Spacewalk-list] OracleXE to Postgresql mig problem

Daniel Souvignier Tue, 07 Jan 2014 02:39:21 -0800

Strange... That should work, it is even standard SQL language...


Am 07.01.2014 11:13, schrieb Z(eljko Dokman:


I got this error..

spaceschema=# create table log;

ERROR: syntax error at or near ";"

LINE 1: create table log;

*From:*[email protected] [mailto:[email protected]] *On Behalf Of *Daniel Souvignier

*Sent:* Tuesday, January 07, 2014 10:08 AM
*To:* [email protected]
*Subject:* Re: [Spacewalk-list] OracleXE to Postgresql mig problem

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 Z(eljko Dokman:

    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:[email protected]  
<mailto:[email protected]>  
[mailto:[email protected]] On Behalf Of Milan Zázrivec

    Sent: Friday, January 03, 2014 5:03 PM

    To:[email protected]  <mailto:[email protected]>

    Subject: Re: [Spacewalk-list] OracleXE to Postgresql mig problem

    On Friday 03 January 2014 15:55:01 Z(eljko Dokman wrote:

        Hi all

        I need some help with migrating my spacewalk backend DB from Oracle XE

        to PostgreSQL.

        I am following instructions from

        https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle

        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?

    Has your PostgreSQL schema been properly populated?

    Do your Oracle and PostgreSQL schema versions match?

-MZ

    _______________________________________________

    Spacewalk-list mailing list

    [email protected]  <mailto:[email protected]>

    https://www.redhat.com/mailman/listinfo/spacewalk-list




    _______________________________________________

    Spacewalk-list mailing list

    [email protected]  <mailto:[email protected]>

    https://www.redhat.com/mailman/listinfo/spacewalk-list




--
----------------------------------------------------------------
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

www.ias.rwth-aachen.de <http://www.ias.rwth-aachen.de>


_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list



--
----------------------------------------------------------------
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
www.ias.rwth-aachen.de

smime.p7s
Description: S/MIME Kryptografische Unterschrift

_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] OracleXE to Postgresql mig problem

Reply via email to