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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 17 Oct 2007 11:51:11 -0700
Message-ID: <1192647071.961041.198440@q5g2000prf.googlegroups.com>

On Oct 17, 11:34 am, DA Morgan <damor..._at_psoug.org> wrote:
> sonu 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.
>
> Your request is far from clear but you might want to look here:http://www.psoug.org/reference/import.html
> specifically at the FROM USER and TO USER syntax.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

The traditional exp and imp utilities do not supporting importing Table_A into another table by any other name other than Table_A. You can switch owners but not table_names.

Look at CTAS (create table as select). You might be able to perform a CTAS or use CTAS in conjuction with exp/imp activity to perform the task. The rename command might also be of use in this task or a database link if you are crossing platforms.

HTH -- Mark D Powell -- Received on Wed Oct 17 2007 - 13:51:11 CDT