Re: copying tables from one database to another
From: gazzag <gareth_at_jamms.org>
Date: Wed, 20 Jan 2010 04:41:36 -0800 (PST)
Message-ID: <d3c7a154-240e-4e38-89c8-c7690af7f3ef_at_m16g2000yqc.googlegroups.com>
On 20 Jan, 11:35, Andrew <marlow.and..._at_googlemail.com> wrote:
> How do people copy tables from one database to another? The docs say
> that imp/exp are deprecated. I tried the copy command in sqlplus but
> it destroys the indexes and default attributes! Arrgghh.
>
> I have a feeling sql loader can be used to do the import but how do I
> do the export first? Obviously any export will have to produce a file
> that is suitable for use to sql loader.
>
> Excuse my ignorance: I am more used to sybase where you can use bcp to
> bcp-out followed by bcp-in.
>
> Regards,
>
> Andrew Marlow
Date: Wed, 20 Jan 2010 04:41:36 -0800 (PST)
Message-ID: <d3c7a154-240e-4e38-89c8-c7690af7f3ef_at_m16g2000yqc.googlegroups.com>
On 20 Jan, 11:35, Andrew <marlow.and..._at_googlemail.com> wrote:
> How do people copy tables from one database to another? The docs say
> that imp/exp are deprecated. I tried the copy command in sqlplus but
> it destroys the indexes and default attributes! Arrgghh.
>
> I have a feeling sql loader can be used to do the import but how do I
> do the export first? Obviously any export will have to produce a file
> that is suitable for use to sql loader.
>
> Excuse my ignorance: I am more used to sybase where you can use bcp to
> bcp-out followed by bcp-in.
>
> Regards,
>
> Andrew Marlow
What version of Oracle? A couple of suggestions:
- As you say, imp and exp are deprecated but have been superceded by DataPump:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/part_dp.htm#i436481
2. Create a database link and CREATE TABLE AS SELECT or INSERT INTO ...over the link.
Some more ideas here:
http://groups.google.co.uk/group/comp.databases.oracle.server/browse_thread/thread/25d55ebf0e706312/f7aea9b2c161a1b8?hl=en#f7aea9b2c161a1b8
HTH -g Received on Wed Jan 20 2010 - 06:41:36 CST