Timeline for How to approach copying a schema for testing?
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 30, 2016 at 18:14 | vote | accept | user447607 | ||
| Aug 30, 2016 at 14:35 | history | tweeted | twitter.com/StackDBAs/status/770630970307407873 | ||
| Aug 30, 2016 at 5:48 | comment | added | Justin Cave | What version and edition of Oracle are you using? Creating snapshot copy databases as one of the answers suggests is a good option. If you're not using 12.1 with the multitenant option, however, you might want configure the database so you can do a flashback to a guaranteed restore point which is your "gold". That may not be a 20 second solution but it is probably better than 8 minutes. | |
| Aug 29, 2016 at 20:00 | answer | added | Balazs Papp | timeline score: 3 | |
| Aug 29, 2016 at 19:38 | comment | added | user447607 | We are also working on an alternate track which would generate unique schema names via Jenkins build number. | |
| Aug 29, 2016 at 16:34 | history | edited | user447607 | CC BY-SA 3.0 |
added 193 characters in body
|
| S Aug 29, 2016 at 16:31 | history | suggested | Tara Kizer |
Added Oracle tag
|
|
| Aug 29, 2016 at 16:17 | review | Suggested edits | |||
| S Aug 29, 2016 at 16:31 | |||||
| Aug 29, 2016 at 16:14 | history | asked | user447607 | CC BY-SA 3.0 |