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

Threaded View

  1. #1
    Join Date
    Nov 2000

    Question 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

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.