Re: dumping a table in sql insert format?

On 18 mai, 03:24, DA Morgan <damor..._at_psoug.org> wrote:
> Mark Harrison wrote:
> > DA Morgan <damor..._at_psoug.org> wrote:
> >> Mark Harrison wrote:
> >>> What's the best way to dump some tables into a file
> >>> such that the data is in a series ofinsertstatements?
>
> >>> I would like to set up some regression tests for my
> >>> database, and this is the seed data that is needed
> >>> after the schema has been created.
>
> >>> TIA!
> >>> Mark
>
> >> SELECT 'INSERTINTO t VALUES (' || srvr_id || ')' FROM servers;
>
> >> Wouldn't external tables be easier?
>
> > Well, here's my goal, any suggestions appreciated...
>
> > I want to be able to easily set up and tear down a development or test
> > environment. Ideally such things as sequences will all be initialized
> > to known values, so that regression testing is as easy as possible,
> > e.g. doing simple string comparisons (dates/times are the main
> > trouble here).
>
> My choice would be to set it up once.

I second this...

> Turn on archiving and flashback.
> Create a guaranteed restore point.
> And at the end of each run just FLASHBACK DATABASE TO <restore_point>;

If regression does not include performance tests, I would also consider VMWare.

• Snapshots allow you to build an history tree, which you can quickly navigate.
• The test environment is easily duplicated and distributed to different developpers/locations
  • Raoul