Re: export to different oracle user...

I usually uise the imp and exp commands after being logged as oracle user with a telnet session...

the solution fromuser => touser seems to be good, i'll try it now.

thank you.

FLORENT G. "nettdata" <nettdata_at_noSpAM_nettdata.com> a écrit dans le message news: 3D3422EE.10808_at_noSpAM_nettdata.com...
> 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:48:22 CDT