Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Data export from oracle 10G to SqlServer 2000

Re: Data export from oracle 10G to SqlServer 2000

From: sybrandb <sybrandb_at_gmail.com>
Date: 7 Aug 2006 05:50:58 -0700
Message-ID: <1154955058.055557.120000@n13g2000cwa.googlegroups.com>

aamir.majeed_at_gmail.com wrote:
> Actually I did such work between two SqlServers but what I felt that it
> is more efficient to
> take data out from database in file and then insert that files on
> database.
>
> Rgrds

Any benchmarks to support this assertion? To me using flat files would typically be much slower, and more dangerous.
Disk volumes can fill up. This is one of the typical actions that would fill up a disk volume, especially if you don't clean up your 'temporary' files.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Mon Aug 07 2006 - 07:50:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US