RE: Migrate users from 10-11
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "stmontgo@xxxxxxxxx" <stmontgo@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2011 16:44:39 +0100
Hi,
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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of steve montgomerie
Sent: woensdag 30 november 2011 16:12
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
