RE: Migrate users from 10-11
Date: Wed, 30 Nov 2011 10:55:22 -0500
Message-ID: <03f201ccaf78$7853b5b0$68fb2110$_at_rsiz.com>
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.
Regards,
mwf
-----Original Message-----
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.
Thanks
Steve
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 30 2011 - 09:55:22 CST