RE: Migrate users from 10-11

From: Mark W. Farnham <>
Date: Wed, 30 Nov 2011 10:55:22 -0500
Message-ID: <03f201ccaf78$7853b5b0$68fb2110$>

If no one has a better way, you can:
  1. make a clone of the minimal database parts
  2. offline drop all the user data tablespaces including contents
  3. upgrade what is left
  4. export full
  5. import on the new server
  6. add back the tablespaces you dropped
  7. add back any direct grants on sys objects in the original database, if you really still want them.
  8. 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.



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

From: [] On Behalf Of steve montgomerie
Sent: Wednesday, November 30, 2011 10:12 AM To:
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.



-- Received on Wed Nov 30 2011 - 09:55:22 CST

Original text of this message