Re: SQL 'DUMP' From Oracle - How?

Hi Mark,

Yeah, you have to write a fiddly query like so:

• Set up the environment to minimize editing of the output SET HEAD OFF SET PAGES 0 SET FEEDBACK OFF SET COLSEP ',' SPOOL <file_name>.SQL

SELECT * FROM <table_name>;

SPOOL OFF

• If you are a neatnik clean up the environment

SET COLSEP ' '
SET FEEDBACK ON
SET PAGES 24
SET HEAD ON The output will be a nice comma delimited file all ready to load into any RDBMS with a utility smart enough to handle a delimited file.

Regards

Jerry

Mark Tortolano wrote:
>
> Hi there,
>
> I'm trying to dump the contents of a table, in order to create a
> series of SQL INSERT statements. I know the functionality of Export,
> but I just want to create INSERT statements, not an Oracle-specific
> binary.
>
> How do I do this? Is the only way to create a (fiddly) SQL*Plus
> report, using headings, separators, etc, or is there a better way?
>
> Thanks,
>
> Mark Tortolano

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group