3 Replies Latest reply: Nov 7, 2013 7:12 PM by scott.wesley RSS

    refreshing Dev workspace from Prod

    Steve.1234555-Oracle

      Hello,

       

      I suport an APEX app that has one workspace for Development and one for the live Production application.  When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time).  The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date.

       

      I would like to do a couple things:

      1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical

      2) execute SQL to truncate Dev tables and refresh from Prod

       

      Is there a way to do this?  Suggestions?

       

      thanks,

      Steve