Re: Moving user to another instance...

Jimmy wrote in message <361B5482.1C381744_at_comp.polyu.edu.hk>...
>Hello all.
>
> Is it possible to move all users in instance A to another instance
>B? And how to do it? Where the user's default tablespace? Is the role,
>privileges are move to instance B also?

Yes, that's possible. Use sys.dba_users dictionary view to get all necesary information about user name, encrypted password (use 'identified by values' feature of create or alter user), tablespaces and profile and write a proper script. From sys.dba_role_privs and sys.dba_tab_privs (maybe sys.dba_col_privs) u may get all user grants.

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Wed Oct 07 1998 - 13:17:59 CDT