Re: ALTER USER scott IDENTIFIED BY VALUES ???

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Apr 2006 06:50:18 -0700
Message-ID: <1144158618.274123.160250@j33g2000cwa.googlegroups.com>

You can set the passwords for the users on database B to the values in database A the same way Oracle imp/exp does it.

Depending on how close these databases are in design you might be able to drop the non-owner users and recreate them via an import of a rows=n export.

Or it may be easier and cleaner to just use SQL to generate the alter user statements on database A and then run the alter script on database B.

I have posted a create users generation script on metalink in the past.

HTH -- Mark D Powell -- Received on Tue Apr 04 2006 - 08:50:18 CDT