Re: How to dump table contents as SQL statements?
From: duncanz <duncanzNOduSPAM_at_dds.nl.invalid>
Date: Wed, 26 Jan 2000 05:25:41 -0800
Message-ID: <11f733ec.70d2e440_at_usw-ex0110-075.remarq.com>
Date: Wed, 26 Jan 2000 05:25:41 -0800
Message-ID: <11f733ec.70d2e440_at_usw-ex0110-075.remarq.com>
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>_at_<source_alias> -
to <target_username>_at_<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