Bucknell maintains three complete end-to-end environments (development, UAT, and production). Refreshing non-production environments becomes more complicated when Oracle Streams components are involved. This session will walk through Bucknell's post-clone procedures for BEIS Streams (local-host), BPRA Streams to the ODS/EDW staging area (cross-host), updating OWB locations, and refreshing ODS/EDW data. Bucknell typically refreshes DEV from PROD on a monthly basis and UAT from PROD on a weekly basis. By cloning the Banner and ODS/EDW databases simultaneously and resetting the instantiation SCN of objects in the ODS/EDW staging area, Bucknell avoids a full reload of the ODS and EDW.