[Spacewalk-list] OracleXE to Postgresql mig problem

[Daniel Souvignier]

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:*spacewalk-list-bounces at redhat.com 
> [mailto:spacewalk-list-bounces at redhat.com] *On Behalf Of *Daniel 
> Souvignier
> *Sent:* Tuesday, January 07, 2014 10:08 AM
> *To:* spacewalk-list at redhat.com
> *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:spacewalk-list-bounces at redhat.com  <mailto:spacewalk-list-bounces at redhat.com>  [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Milan Zázrivec
>
>     Sent: Friday, January 03, 2014 5:03 PM
>
>     To:spacewalk-list at redhat.com  <mailto:spacewalk-list at redhat.com>
>
>     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 at 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
>
>     Spacewalk-list at redhat.com  <mailto:Spacewalk-list at redhat.com>
>
>     https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
>     _______________________________________________
>
>     Spacewalk-list mailing list
>
>     Spacewalk-list at redhat.com  <mailto:Spacewalk-list at redhat.com>
>
>     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
> Spacewalk-list at redhat.com
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/cecd7052/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4302 bytes
Desc: S/MIME Kryptografische Unterschrift
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/cecd7052/attachment.p7s>