I have recently joined a Team where they execute their DB Changes bundled in a sql scripts. For Prod Readiness - They refresh Databases in multiple environments. Pick up 1 env, say Test1, execute sql scripts and if it fails, fix the errors in script. Now Pick up another Env, say Test2, run it here and keep going on until it all succeeds i.e. spool is all clean! Can we not restrict it all to just 1 environment by creating a Restore Point before script execution and using Flashback after execution, and do it on repeat until the spool comes clean? Am I missing something? Any drawbacks of using Flashback? Any alternatives or other considerations to use Flashback?
0
There are 0 best solutions below
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in FLASHBACK
- In Oracle 18c+, Is it possible to use Table Flashback with a reference partitioned table?
- Does a Restore Point Persist after Flashback/Point-in-time?
- Oracle DB - Flashback functionality
- How can I retrieve the value of an attribute supported by Oracle?
- Flutter TextFormField: The keyboard appeared and instantly disappeared
- What is going on underneath FDA queries?
- How to restore an earlier version of a table from recyclebin?
- How do I properly use Oracle Flashback to audit table changes with user information?
- How do I add Oracle Flashback columns to a .Net Core Entity Framework EDMX on affected entities?
- Using ORACLE Flashback with QueryDSL
- How do I exclude unchanged fields in Flashback query resultset?
- Cannot drop Oracle flashback data archive
- What is Read ONLY Role to give to Oracle developers to veiw the Flashback Data via versions Query
- Maximum number of days SCN retains, to query archived data
- Oracle Flashback Archive and ORA-08181: specified number is not a valid system change number
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?