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 Ž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]] On Behalf Of Milan Zázrivec Sent: Friday, January 03, 2014 5:03 PM To: [email protected] 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@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] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ 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 cryptographic signature
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
