[Spacewalk-list] Problems with db import from oracle to postgres

[Silvio.Schanz at elektrobit.com]

Hi,

fgrep -B1 rhnpackagerepodata spacewalk-oracle.dmp
...
-- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE DATE
copy rhnpackagerepodata(package_id,primary_xml,filelist,other,created,modified) from stdin;
...

Regards,
  Silvio 

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Tuesday, July 12, 2011 3:56 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Problems with db import from oracle to postgres

On Tue, Jul 12, 2011 at 01:44:20PM +0000, Silvio.Schanz at elektrobit.com wrote:
> Hi Jan,
> 
> This is my output from
> fgrep rhnpackagerepodata spacewalk-oracle.dmp ..
> copy rhnpackagerepodata(package_id,primary_xml,filelist,other,created,modified) from stdin; 9 \x1fÂ\x08\x00\x00\x00\x00\x00\x00\x00                     ½I\x0aHÃnz[){7WýÂúT\x193Â\x1b¹¶a7ýõ\x1dCÂÂ¥jÃÃx17ÂñÂ9ÂÂ3°¦lGs f_C䨺tâ°¢%Ã

We need the

	-- Types for 

line which is right before that copy line.

--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list


----------------------------------------------------------------
Please note: This e-mail may contain confidential information
intended solely for the addressee. If you have received this
e-mail in error, please do not disclose it to anyone, notify
the sender promptly, and delete the message from your system.
Thank you.