I would like to export all user and roles objects from Oracle 10g database to another. I googled it but I cannot find out how to do it.
First I use this command:
exp system/root@[DB_Name] file=[Back_file_name] owner=([Owner_Name])
But the problem was that some table settings depend on user privileges. Hence I want to also export user objects.
For example it is possible to export all objects with this command:
exp system/root@[DB_Name] Full=Y file=[Back_file_name]
But this command does not export the needed objects for me.
I would like to export only:
- tables by owner name
- all users
- maybe roles
Is this possible?