Re: Import dmp into table of a different name ?

On Mar 8, 10:10 pm, "Ed" <e..._at_mail.com> wrote:
> -10gR2-
>
> Say I expdp (from my schema) the table "emp"
> I then want to impdp into a non-existent table "emp_2"
> How to do this ?
>
> thanks

Import it and then rename it with alter table.

If you already have an emp, rename that first, then rename it back after doing the other one.

Depending on where you are coming from and going to, you may also want to use Create Table As Select instead of impdp.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20070309/news_1b9adcs.html