This content has been marked as final. Show 4 replies
Pl identify the process you used to upgrade the "test" database - you will need to follow the same process again1 person found this helpful
I did an exp and imp full. I created a blank plain database and created the tablespaces. then I imported the exp dump. I just got the confusion because by then the db was fresh, but now there is some data (which is two/three months old).
I am doing a full exp and then import and see.
Make a full export but only import the application schema's.1 person found this helpful
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.
You should be doing full export and import as you did in the first case. But you need to keep in mind if you added something during last 3 months in production, which will not be tested.