Re: copying tables from one database to another
From: joel garry <joel-garry_at_home.com>
Date: Wed, 20 Jan 2010 08:45:12 -0800 (PST)
Message-ID: <049f5411-de6d-4842-b3d0-d198b1816d5e_at_a32g2000yqm.googlegroups.com>
On Jan 20, 3:35 am, 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 08:45:12 -0800 (PST)
Message-ID: <049f5411-de6d-4842-b3d0-d198b1816d5e_at_a32g2000yqm.googlegroups.com>
On Jan 20, 3:35 am, 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
impdb/expdp is the basic tool you should become adept with, in addition to what the others noted there are some older ways: http://tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html
jg
-- _at_home.com is bogus. The getting an immigrant visa the old fashioned way; money! http://www.eb5greencard.com/eb5visa.phpReceived on Wed Jan 20 2010 - 10:45:12 CST