Post reply

Insert Commit Size with Oracle

  • August 10, 2005 at 9:39 am

    #60779

    Does anyone know if there's an equivalent to the 'Insert Commit Size' option when transferring data between Oracle and SQL Server 2000 databases please?  If not, are there any workarounds?

    Thank you.

  • August 10, 2005 at 10:08 am

    #581106

    If you transfer data using sql server DTS, then there is a batch size option, not sure of any other way.

  • August 11, 2005 at 1:58 am

    #581301

    Thank you Ray, but I think this option only applies when transferring between SQL Servers.  Oh for homogeneous data sources...

    Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply