Re: Migrate users from 10-11
Date: Wed, 30 Nov 2011 15:56:37 +0000
> ...We took a datapump extract from Oracle
> 10, extracted the create user DDL and tried to create the users
> in Oracle 11 with the password hash however that does not work.
I recently migrated a 9i database to 11g with no problems. I used Toad to extract a script which looked like:
create user ... identified by values 'lots of hex here' ...
And it worked fine after the import. It's possible you'll need to trun off case sensitive passwords first though, check your "sec_case_sensitive_logon" parameter.
I'm not saying it will be that that's making things not work, but it could be.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 30 2011 - 09:56:37 CST