Database DataWarehousing (MOSC)

MOSC Banner

11gR2 : remote insert with parallelism

edited Oct 11, 2013 5:50AM in Database DataWarehousing (MOSC) 1 commentAnswered
Hi ,

How to improve performance of an " remote" INSERT by using parallellism, append ,  ... :

INSERT into remote_table@dblink(select col1, col2,... from local_table);

Best regards.

GD.

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