Is there a Oracle equivalent of mysqldump
Posted
by
Rakhitha
on Stack Overflow
See other posts from Stack Overflow
or by Rakhitha
Published on 2011-03-15T15:54:00Z
Indexed on
2011/03/15
16:09 UTC
Read the original article
Hit count: 334
Is there a way to dump the content of a oracle table in to a file formated as INSERT statements. I can't use oradump as it is on GPL. I will be running it from a perl CGI script. I am looking for something to dump data directly from oracle server using a single command. Running a select and creating insert statements using perl is too slow as there will be lot of data.
I know I can probably do this using spool command and a plsql block at server side. But is there a built in command to do this instead of formating the INSERT statements myself?
© Stack Overflow or respective owner
