sql dumper?

From: <lopezd_at_sni13.viacom.com>
Date: 1998/03/03
Message-ID: <6dhme7$oog$1@nnrp1.dejanews.com>#1/1

Hello,

I need to transfer data between Oracle and Sybase using very simple tools since I don't want to get into the intricacies of replication servers and the like. Bcp in Sybase will allow me to export and import rows from a table. As far as I know Oracle only has sqlloader as the bcp equivalent and it only goes in not out. Is my only solution to use the spool command with an appropriate column seperator? I could build a script to automate such a thing, but it seems there must be a better way.

Regards,

Dave

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 03 1998 - 00:00:00 CST