Re: copy data of one table to anothere from export (dump) file

From: gpmilliken <gpmilliken_at_gmail.com>
Date: Wed, 17 Oct 2007 20:18:29 -0000
Message-ID: <1192652309.327678.309510@z24g2000prh.googlegroups.com>

On Oct 17, 7:15 am, sonu <ajit.bak..._at_gmail.com> wrote:
> Hi,
>
> There is one export dump file say exp.dmp. From that dump file i want
> to load data of table say X into Y which is same as X schema wise. Is
> it possible?
>
> Regards,
> AB.

If you are asking if you can export a table, and then reload it into a different schema -- the answer is YES. Look at the import command TOUSER parameter. If your FROMUSER and TOUSER are different (and valid) you can migrate a table this way.

FYI IMPORT and EXPORT are deprecated, so look at data pump as a possible replacement if you are on a version that supports data pump.

George P. Milliken Received on Wed Oct 17 2007 - 15:18:29 CDT