This content has been marked as final. Show 4 replies
Make a full export but only import the application schema's.
Before doing that you have to drop the application schema user (cascade) and create the user again.
The related tablespaces will still be there but they are empty because of dropping the schema user.
After that you can import only the application schema's from the full export.
Finally your production database is still the same but the application schema is updated with the latest data from the export dump.