need to create a test enironment on the production server
Due to resource limitaions, I need to create a test evironment on the same production server. I know it is horrible, but I have no choice. I think the best route to do this is to create another schema but I am not sure what do about all the public synonyms from production db (seq, tables, procedures. etc..) as well as database links.
I guess my question how can I do this so that I have exactly the same prod database and when I am finished testing, I can move the test db to prod db ?
Last edited by ocpdude; 03-12-2007 at 01:22 PM.
Reason: this should have been posted in the DBA forum