RE: Migrate users from 10-11
Date: Wed, 30 Nov 2011 10:55:22 -0500
If no one has a better way, you can:
- make a clone of the minimal database parts
- offline drop all the user data tablespaces including contents
- upgrade what is left
- export full
- import on the new server
- add back the tablespaces you dropped
- add back any direct grants on sys objects in the original database, if you really still want them.
- proceed with your datapump.
or something approximating that depending on your exact circumstances. If you have massive amounts of source$ and you plan to re-build your pl/sql stuff from scripts on 11g anyway, you might want to generate drop all packages and procedures scripts on the clone before the export.
That is an overview as best I can remember it off the top of my head. UNTESTED, so I might have left something out, and it has been a while. You'll probably have some grant (see CONNECT) and role changes to make to match up with changes in the security model.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of steve montgomerie
Sent: Wednesday, November 30, 2011 10:12 AM 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.
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 09:55:22 CST