Re: recommended way of exporting/importing big data sets
From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 11 Mar 2009 08:09:07 -0700 (PDT)
Message-ID: <1c5fb25b-afa8-40bf-a2be-3834dd070064_at_y38g2000prg.googlegroups.com>
On Mar 11, 5:16 am, ciapecki <ciape..._at_gmail.com> 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.
Date: Wed, 11 Mar 2009 08:09:07 -0700 (PDT)
Message-ID: <1c5fb25b-afa8-40bf-a2be-3834dd070064_at_y38g2000prg.googlegroups.com>
On Mar 11, 5:16 am, ciapecki <ciape..._at_gmail.com> 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.
Did you read about network mode for data pump? http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_import.htm#i1006584
-- Regards, Greg Rahn http://structureddata.orgReceived on Wed Mar 11 2009 - 10:09:07 CDT