Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LINKED SERVER PERFORMANCE FOR ORACLE DATABASE

Status
Not open for further replies.

13415

Programmer
Jul 9, 2001
17
US
I AM USING LINKED SERVER TO POPULATE ORACLE DATABASE FROM SQL SERVER 7.0. INSERT IS TAKING MUCH MORE TIME THAN NORMAL ORACLE INSERT
PLEASE LET ME KNOW , HOW CAN I IMPROVE THE PERFORMANCE OF LINKED SERVER.

THANKS
 
If it's a one-time data xfer, or something that needs to run once a week, I would use the export function in SQL/Server Enterprise Manager and then import that file using Oracle's SQLLDR. Mike
"Experience is the comb that Nature gives us after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top