Re: recommended way of exporting/importing big data sets

From: Michael Austin <>
Date: Thu, 12 Mar 2009 17:15:42 -0500
Message-ID: <yOful.9478$>

ciapecki wrote:
> What is the recommended method to export and later import big tables
> (1-5 Mio rows with ca. 50 columns)?
> database oracle 10gR2
> Goal, Copy some big tables from remote DB1 (no filesystem access, no
> DBA role, etc.) to locally managed DB2 (full access).
> I checked datapump but it requires to create a DIRECTORY on server
> side. I am only a normal user on that database and without access to
> filesystem.
> is the old exp/imp good approach, or there are better ones (create
> table over database link)?
> thanks,
> chris

you "could" install DB2Connect on the Oracle box and use Heterogeneous Services to create a DB link to the DB2 db and just insert into ... select * from ... Received on Thu Mar 12 2009 - 17:15:42 CDT

Original text of this message