Re: Migrate users from 10-11

From: Norman Dunbar <>
Date: Wed, 30 Nov 2011 15:58:57 +0000
Message-ID: <>

Hi Niall,

On 30/11/11 15:48, Niall Litchfield wrote:
> The password hash changes in 11!

Did it? I never saw that in new features.

Anyway, I see the same hash in my 11g database for a user that exists in a 9i database - both have the same password.

Mind you, getting the hash has definitely changed - it's in DBA_USERS in 9i and sys.user$ in 11g. NULLs all round in 11g DBA_USERS.

I can even login to the 11g user - which was created using a script with the "identified by values" extracted from 9i.


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Wed Nov 30 2011 - 09:58:57 CST

Original text of this message