Re: dbmove utility?

On Fri, 23 May 2003 00:12:37 +0100, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>"Harry Boswell" <hboswel1_at_bellsouth.net> wrote in message
>news:setncvkt6psh1jh5q8d8bt1quoatrdkvcj_at_4ax.com...
>> One of our consultant programmers was telling me about a DB2 utility
>called
>> dbmove that could quickly replicate databases. He thought this utility
>had
>> been ported to Oracle. Does anybody know what he's talking about? A
>quick
>> Google search didn't turn up anything that sounded like what he was
>> referring to.
>>
>> Thanks,
>> Harry Boswell
>
>I doubt that there's anything that gets 'ported from DB2 to Oracle'.
>
>But there is a perfectly good utility to move the contents of an Oracle
>database from one machine/operating system to another, using an OS-agnostic
>binary file. Surprisingly enough, it is called exp and imp.
>

The conversation came up because of import. We were talking while I was running an import, which is currently taking 5-6 hours. He also works with a project using DB2 databases.

Most of the time in the import is taken up by one table with a LONG column. From re-reading the manuals, imp imports a table with a LONG column one row at a time, regardless of the BUFFER, so I'm not accomplishing anything by setting BUFFER= to a high value, right? Any tweaks specifically for tables with LONG columns?

Thanks,
Harry Boswell Received on Fri May 23 2003 - 15:45:41 CDT