Re: How to dump table contents as SQL statements?

Hi, you can maybe also use Oracle SQL*Plus copy facility. If you can reach both databases from the same client then u can use following syntax:

copy from <source_username>@<source_alias> - to <target_username>@<target_alias> -
append <target_table> -
using <select_stmnt_on_source>

be sure not to forget the dash at the end of every line, unless it's the last.

enjoy.

Duncan

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful