buckey
April 27th, 2007, 11:57 AM
I have recently been charged with the task of refreshing an oracle database. Unfortunatly I am not very experienced with oracle. This poses a rather daunting challenge. Anyway, I will try to get pointed in the right direction by any guru's willing to share their knowledge with me.
The way the refresh procedure was explained to me was that our development environment will be refreshed with our production environment. This is more or less a copy for lack of better terms. (Forgive me as i am a newbie)
So, after this copy takes place there is fresh data in our development environment. However, the catch is that all changes made to the dev environment and not the prod environment will not be in the newly refreshed dev environment. This requires re applying all changes made to the development environment which have not made it to the production environment prior to the refresh.
Here is the problem. I have only half a solution. Here is what i am planning on doing. First, i wrote a program to select all text from dba_source for each package, package body and trigger between the two refresh dates. This seems as though it would, in theory work great.
For the second thing i am having an issue with is finding out what alter statements have been made in that time period. That way, i can make the appropriate changes to my newly created dev environment tables. Is there oracle logs or anything like that i can have my program search through to determine what has been applied to make sure my tables are the same?
at any rate, please give me some ideas on how to get around this issue. Any suggestions are greatly appreciated. Thanks in advance!
i am using oracle 10g.
The way the refresh procedure was explained to me was that our development environment will be refreshed with our production environment. This is more or less a copy for lack of better terms. (Forgive me as i am a newbie)
So, after this copy takes place there is fresh data in our development environment. However, the catch is that all changes made to the dev environment and not the prod environment will not be in the newly refreshed dev environment. This requires re applying all changes made to the development environment which have not made it to the production environment prior to the refresh.
Here is the problem. I have only half a solution. Here is what i am planning on doing. First, i wrote a program to select all text from dba_source for each package, package body and trigger between the two refresh dates. This seems as though it would, in theory work great.
For the second thing i am having an issue with is finding out what alter statements have been made in that time period. That way, i can make the appropriate changes to my newly created dev environment tables. Is there oracle logs or anything like that i can have my program search through to determine what has been applied to make sure my tables are the same?
at any rate, please give me some ideas on how to get around this issue. Any suggestions are greatly appreciated. Thanks in advance!
i am using oracle 10g.