I think this is an excellent topic. I work in a regulated industry, and we need to move our systems through many environments before it's production ready.
Basically I've found no good way to automate this. I typically have a control script which calls other scripts. The other scripts are...
Oh, it definiately happened -- an attempt to restore two tables truncated over 30 others. Unfortunately I didn't save the log file. Let me try and create a test example.
~ ~ David
Importing data for selected tables from a data file that contains data for many tables, and choosing the truncate option causes ALL tables to be truncated (not just the selected ones), and only the selected ones get repopulated. This is *extreemly* annoying. I just lost all development data...
I actually do the same thing -- I force terminate PL/Dev to preserve a session.
Can this be logged as a request to provide an option to save the current session as a named session?
~ ~ David