Re: Exporting and imporing table data to another user

Kim,

It is possible to do an import with the parameters fromuser and touser. At the
command line type:

    exp login/password file=filename fromuser=<old owner> touser=<new owner>

If you only want a single table or a few tables from the export add the parameter tables and specify the required tables.

Terry Ball
Sr. DBA, CSG Systems

Kim Amouche wrote:

> Hi !
>
> I have successfully used Oracles IMP and EXP utility to move data from
> one database to another database.. But I would like to move some
> tables and/or table data from one DB user to another DB user.
>
> Anyway of doing this with EXP / IMP ?
> If not what other tool can I use ?
>
> I have an Oracle 7.3.2 base...
>
> -
> Best Regards - Kim
Received on Thu Jan 14 1999 - 09:19:12 CST