Re: recommended way of exporting/importing big data sets

From: Greg Rahn <>
Date: Wed, 11 Mar 2009 08:09:07 -0700 (PDT)
Message-ID: <>

On Mar 11, 5:16 am, 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.

Did you read about network mode for data pump?

Greg Rahn
Received on Wed Mar 11 2009 - 10:09:07 CDT

Original text of this message