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 ?