Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dumping a table in sql insert format?
"Mark Harrison" <mh_at_opixar.com> wrote in message
news:sn13i.663$C96.334_at_newssvr23.news.prodigy.net...
> What's the best way to dump some tables into a file
> such that the data is in a series of insert statements?
>
> 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
>
> --
> Mark Harrison
> Pixar Animation Studios
A tool like InfoMaker can do that automatically. It's one of the options
when saving data.
It shouldn'tbe difficult to write a little pl/sql block using some dynamic
sql to generate a text file with all the insert statements.
-- Terry DykstraReceived on Thu May 17 2007 - 14:11:20 CDT
![]() |
![]() |