Re: copying tables from one database to another

From: joel garry <>
Date: Wed, 20 Jan 2010 08:45:12 -0800 (PST)
Message-ID: <>

On Jan 20, 3:35 am, Andrew <> 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:


-- is bogus.
The getting an immigrant visa the old fashioned way; money!
Received on Wed Jan 20 2010 - 10:45:12 CST

Original text of this message