Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

refreshing Dev workspace from Prod

Steve.1234555-OracleNov 6 2013 — edited Nov 7 2013

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 5 2013
Added on Nov 6 2013
#apex, #apex-discussions, #database, #refresh
3 comments
419 views