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

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing the name of a DB user

Re: Changing the name of a DB user

From: Olivier Bercovitz <oberco_at_club-internet.fr>
Date: 1998/03/23
Message-ID: <3516D66A.4D6DA368@club-internet.fr>#1/1

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

Original text of this message

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