I want to refresh a development database with production data. The database size is around 3GB. As this is a full EXPORT and IMPORT of the database, how can i truncate the before data in development instance? I can directly IMPORT but that would leave some duplicate data. So, i would like to clean the development database first and then IMPORT with the new production data. Do i have to go and do a truncate at each user level or is there any way to get around this problem?
Also, do we have to do a FULL database export as SYS? or will the SYSTEM work?
Any information will be of great help.