RE: Migrate users from 10-11

Datapump will recreate the users for you. You can also create them manually and use the "identified by values "<hashed password>" syntax.

When doing schema level datapump imports you must also remember that datapump will only grant you privileges on the schema objects you are importing. So any privilege on sys objects (eg execute on dbms_alert) will not be granted during the import. (as sys is not exported during database level exports, the same example should be true for database level imports).

Regards,  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of steve montgomerie Sent: woensdag 30 november 2011 16:12
To: oracle-l_at_freelists.org
Subject: Migrate users from 10-11

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? 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.

Thanks

Steve
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 09:44:39 CST