Re: dumping a table in sql insert format?

> 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).

Any reason why you can't use exp/imp? With your schema at a baseline level, do a schema-level export. To restore, drop the schema contents and reimport.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com