Steve,

Thanks for the reply. The main problem seems to be with the export from v6.5 in native mode. He has tried specifying the Code Page directly to no...

Reporing back... again.

I passed this job onto another developer and they have not been able to get a successful transfer going in Native mode.

Firstly, can we confirm that it is...

I have used Views in this manner successfully in the past to cover the following situation:

I needed to write an extract routine to live in a separate Database from the...

Okay, back again (I have someone else working on this right now).

We are using the -V switch on both the export and import using bcp as suggested.

I would...

A brief update - Oracle have informed me that the earliest version of Oracle supported on Windows 2000 Advanced Server is 8.1.7.

Also, the easiest way of un-installing the version that...

Sean / Mike

To report back, I have someone investigating using Replication to do this at the moment.

I took a look at SQLCompare - looked great for the job, then found...

Andy,

TNANAMES.ORA contains connection definitions for each of the Destination Servers in the following format:

BANANA.WORLD =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(Host = 110.110.1.10)(Port = 1521))

...

Steve,

Many thanks once again.

Unfortunately, this transfer was going to get too complicated with about 20 tables to transfer.

I have now opted for an alternative bcp / BULK INSERT solution.

Unfortunately, this...

Okay, I've had another go, setting up a series of Tasks, one for each table and setting the maximum number of Parallel jobs. My problem now is that I...

Thanks for your suggestion.

The job would need to run each day.

The idea was to use DTS for Parallelism, setting it up with three 'streams' of tables to be copied so...