I have a (server 1) 10.2.0.3 on RHEL. I have upgraded it to (server 2) 220.127.116.11.0 on Windows 2003 Server. Tis was done three months back. The user have tested server 2 and said it is OK. Now they are ready to make it "the production" one. Now I have to update the database. (since during the period of testing, the server 1 was production and have more updated data.) How would I do that? Do I have to delete the old database on server 2, again create a new database, and then do the exp and imp? or is there another way?
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.
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.