I want a backup of a schema from our development database. The developers are going to go in there and run programs that will change data. Then they want the data refreshed.


I am planning on exporting the schema. The question is when it is time to refresh the data do I have to drop the user including contents or is there a way just to have the import truncate every table before in inserts the data??? My concern is that if I drop and recreate the user I will lose grants that the user has given to other schemas.