RE: Migrate users from 10-11
Date: Wed, 30 Nov 2011 16:44:39 +0100
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).
Oracle Database Administrator
tel +32(0)3 451 23 82
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
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.
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 09:44:39 CST