Below is my environment :
- sun-solaris , sparc machine
- rac setup
- oracle 11.1
I have a database with many users in it, from which I need to export a particular user data and import it to another machine, with the following configuration:
- sun-solaris , sparc machine
- rac setup
- oracle 12.1
I don't want to perform full database export/import due to few constraints. If I am doing a particular user export/import, what are things I need to do manually like create users, tablespaces and grant permissions, etc, before importing the database? Also how do I know what are the permissions I need to give?