How to complete version of the database migration, including the user name, and database, and the content of the red box need to migrate all, but I only use a user name, and now need to migrate all, one of the other user name also don't know the password, but also need to be migrated, all now is there any way to complete the migration? After migrated to another server can directly use,

CodePudding user response:

When using the exp export plus owner=(u1, u2) parameters

CodePudding user response:

Use expdp export impdp import

CodePudding user response:

You won't even sys and system to migrate the users of the system

CodePudding user response:

Rman backup, and then copy to need to restore the machine, using rman recovery, simply don't tube what users, copy all

CodePudding user response:

Migration to an empty library? The same version?
If new, you can set up the corresponding path, then the file directly to the test in the past