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]] 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 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] 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 Kryptografische Unterschrift
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
