Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting and imporing table data to another user

Re: Exporting and imporing table data to another user

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Tue, 12 Jan 1999 07:49:44 -0500
Message-ID: <369b450f.0@news.mountain.net>


Use the from_user and to_user options of the IMP. You must have export_full_database privilege to do this.

Kenny Gump
OCP 7.3 DBA



Kim Amouche wrote in message <369a7723.3386819_at_195.204.219.242>...
>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 Tue Jan 12 1999 - 06:49:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US