I want to drop a user CASCADE in order to perform a import for this user.
Question 1. If the export was FULL, can I import just FROMUSER my user?
Question 2. When I drop all the schema, what happens with the synonyms, I gess it will be dropped also. When I perform IMPORT FROMUSER, did I lost my synonyms?
How about the permission granted to roles for theses synonyms?
Any input is wellcome, Thanks
2)Yes, if User owns any synonyms(personaly never tested, I guess)
Make sure you create the user before importing and use