Re: recommended way of exporting/importing big data sets
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 17:15:42 -0500
Message-ID: <yOful.9478$%54.1067_at_nlpi070.nbdc.sbc.com>
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
Date: Thu, 12 Mar 2009 17:15:42 -0500
Message-ID: <yOful.9478$%54.1067_at_nlpi070.nbdc.sbc.com>
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