RE: Migrate users from 10-11

From: <>
Date: Wed, 30 Nov 2011 11:20:01 -0500
Message-ID: <>

dba_users has some spots. The identified by values clause now causes an ora-00600. (Turns out this trick has never been supported by oracle).

It works from 11g also:

select 'alter user &&v_user identified by values '||''''||b.password||''''||';' from dba_users a, sys.user$ b
where a.user_id = b.user# and a.username = upper('&&v_user');



Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: [] On Behalf Of D'Hooge Freek Sent: Wednesday, November 30, 2011 10:55 AM To:; Cc:
Subject: RE: Migrate users from 10-11


It is true that the hash changed in 11 (with case sensitive passwords now), but the old hashes are still accepted. I think there is even a flag that tells you if this the password is using the old or the new method.

Kind regards,  

Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----
From: [] On Behalf Of Niall Litchfield Sent: woensdag 30 november 2011 16:48
Subject: Re: Migrate users from 10-11

The password hash changes in 11! Why didn't you just allow datapump to create the users (or whisper it not in Gath) just perform a database upgrade?
On Wed, Nov 30, 2011 at 3:11 PM, steve montgomerie <>wrote:

> Greetings Oracle List!
> We're moving an Oracle Database to a new Server upgrading from 10 to
> 11 with Datapump. Can we migrate the schema's without
> knowing/changing the passwords?

Niall Litchfield
Oracle DBA



Received on Wed Nov 30 2011 - 10:20:01 CST

Original text of this message