Hello all..
I have a Schema 'ABC'in Test Environment where we load the data, test it and move that data to production DB under same schema name...
Now when ABC Schema in TEST database gets new data that includes new tables, new views, update some tables, insert new records into some tables ...etc.
so when i need to move only the updated,new records and new tables or views , what is the best way ?..
Obviously, EXP and IMP is not going to work since IMP doesn't update the existing records..
So can anyone guide me in this process. Any help is appreciated.
Thanks
Ron
I have a Schema 'ABC'in Test Environment where we load the data, test it and move that data to production DB under same schema name...
Now when ABC Schema in TEST database gets new data that includes new tables, new views, update some tables, insert new records into some tables ...etc.
so when i need to move only the updated,new records and new tables or views , what is the best way ?..
Obviously, EXP and IMP is not going to work since IMP doesn't update the existing records..
So can anyone guide me in this process. Any help is appreciated.
Thanks
Ron