Re: recommended way of exporting/importing big data sets

From: <gareth_at_jamms.org>
Date: Wed, 11 Mar 2009 05:29:29 -0700 (PDT)
Message-ID: <3bf67014-3407-487f-9896-0a938a679ffb_at_q27g2000vbn.googlegroups.com>

On 11 Mar, 12:16, 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.
>
> is the old exp/imp good approach, or there are better ones (create
> table over database link)?
>
> thanks,
> chris

exp/imp is perfectly capable of doing what you want.

HTH -g Received on Wed Mar 11 2009 - 07:29:29 CDT