Re: recommended way of exporting/importing big data sets
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 22:43:22 -0500
Message-ID: <LBkul.26075$ZP4.16012_at_nlpi067.nbdc.sbc.com>
Palooka wrote:
>> 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 ...
>>
Date: Thu, 12 Mar 2009 22:43:22 -0500
Message-ID: <LBkul.26075$ZP4.16012_at_nlpi067.nbdc.sbc.com>
Palooka wrote:
> Michael Austin wrote:
>> 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 ...
>>
> I think he means Oracle database #2, not DB2. > > Palooka
don't confuse me like that :-) Received on Thu Mar 12 2009 - 22:43:22 CDT