DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: need to create a test enironment on the production server

Threaded View

  1. #1
    Join Date
    Nov 2000
    Posts
    198

    Question 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
  •  


Click Here to Expand Forum to Full Width