Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing the name of a DB user
Hello Marcus,
sorry but I think (and nearly sure) that exp and imp is the only way to
rename user. I had encountered the same problem one year ago
and it's the only one solution (what solution !!) we find : imp fromuser xxx
touser yyyy
Good luck :-)
Regards. Olivier
Marcus Vogel wrote:
> Hi,
>
> is there another way to change the name of a database user in Oracle 7
> without making an 'exp' of the whole user and the reimport the objects and
> all data for a new user?
>
> A little advise would be very helpful. thanks ...
Received on Mon Mar 23 1998 - 00:00:00 CST