-
need to create a test enironment on the production server
Hi,
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 ?
Thanks,
Last edited by ocpdude; 03-12-2007 at 01:22 PM.
Reason: this should have been posted in the DBA forum
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|