[Spacewalk-list] OracleXE to Postgresql mig problem

[Ž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 Ž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] On Behalf Of Milan Zázrivec
Sent: Friday, January 03, 2014 5:03 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] OracleXE to Postgresql mig problem
 
On Friday 03 January 2014 15:55:01 Ž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
https://www.redhat.com/mailman/listinfo/spacewalk-list






_______________________________________________
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/2df2657f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3741 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/2df2657f/attachment.p7s>