Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

Bulk Insert To MSSQL over Oracle Database Gateway

edited Oct 8, 2012 2:16AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 4 commentsAnswered ✓
Hi all,
I have setup a gateway connection to a mssql server which works as expected.  When I try to perform a bulk insert I get:

ORA-02025: all tables in the SQL statement must be at the remote database

This is expected as bulk inserts are not supported over the database gateway however a post exists on Tom Kyte's site that states the following:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center