[Spacewalk-list] Please help with Oracle to PostgreSQL migration

[Jan Pazdziora]

On Thu, Nov 17, 2011 at 03:18:28PM -0800, James Fillman wrote:
> I'm trying to migrate my Oracle database to PostgreSQL and have failed to do so after 2 tries. Our version of Oracle is 'Oracle Database 10g Release 10.2.0.1.0 - 64bit Production'. Server version: CentOS 5.7
> 
> I've been following the instructions from here: https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle
> 
> The output of the 'spacewalk-dump-schema' command is:
> [root at vacslp01spacewalk 11.2]# spacewalk-dump-schema --db=spacewal --user=spacewalk --password=<password> > /tmp/spacewalk-oracle.dump
> DBD::Oracle::st fetchrow_arrayref failed: ERROR fetching field 2 of 4. LOB value truncated from 30412298 to 10000000. DBI attribute LongReadLen too small and/or LongTruncOk not set [for Statement "select * from rhnactionconfigrevisionresult"] at /usr/bin/spacewalk-dump-schema line 130.
> DBD::Oracle::st fetchrow_arrayref failed: ERROR fetching field 2 of 4. LOB value truncated from 30412298 to 10000000. DBI attribute LongReadLen too small and/or LongTruncOk not set [for Statement "select * from rhnactionconfigrevisionresult"] at /usr/bin/spacewalk-dump-schema line 130.
> 
> After capturing a dump of the oracle database, I continued despite the above errors. I install and configure the postgresql server  as directed.

You should not proceed in spite of the errors. Your dump is
incomplete.

You might want to modify the spacewalk-dump-schema script and increase
that

	LongReadLen => 10_000_000,

value to something bigger, for the error to go away. Make sure there
are no error upon the schema dump.

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