Re: recommended way of exporting/importing big data sets
From: krzysztof cierpisz <ciapecki_at_gmail.com>
Date: Fri, 13 Mar 2009 02:24:40 -0700 (PDT)
Message-ID: <9a5cc741-534f-40d8-9b55-df66f9358152_at_l39g2000yqn.googlegroups.com>
On Mar 13, 4:43 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> 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 :-)
Date: Fri, 13 Mar 2009 02:24:40 -0700 (PDT)
Message-ID: <9a5cc741-534f-40d8-9b55-df66f9358152_at_l39g2000yqn.googlegroups.com>
On Mar 13, 4:43 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> 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 :-)
sorry for the confusion :)
both DBs were Oracle #1 (DB1) and #2 (DB2)
Received on Fri Mar 13 2009 - 04:24:40 CDT