Re: export to different oracle user...

Depending on dependencies (ahh, that doesn't sound right, but you know what I mean) and programatic specifics, you can use the IMP and EXP commands to do so.

Specifically, you can do a normal export (as the original user) and then re-direct the import to a new user:

imp system/manager_at_db file=exp.dmp fromuser=olduser touser=newuser

For details, try "imp help=yes".

This may not work or could get very tricky if you've got multiple schemas with references amongst themselves.

$0.02

...jeff

Florent Gilain wrote:
> Hi all,
>
> I need to export the datas of a specific oracle user (user_01 for example)
> to reimport them into another database that have a different user name :
> user_02 for example..
>
> can anyone give me the way to do it please ?
>
> florent G.
>
>
Received on Tue Jul 16 2002 - 08:42:45 CDT