Thanks Suhen and Jared,
Suppose SQL table consists of 3 columns,
and Oracle table consists of 4 columns.
The first oracle column was Primary Key (Mandatory)
that will get value from sequence.nextval.
How to fill the value for Oracle databases Mandatory columns
that comes from SEQUENCE VALUE
SQL*Loader can generate the sequence values.
Hit the docs to find out, as I don't recall how to do it.
Jared
On Wednesday 27 February 2002 19:58, you wrote:
Thanks Suhen and Jared,
Suppose SQL table consists of 3 columns,
and Oracle table consists of 4 columns.
The first oracle column
One addition to Suhen's mail below - if you are going to be using DTS to
push the data directly to Oracle, be sure to create the destination tables
first, and not let DTS do this. DTS will create the table names in lower
case, so every time you want to select/update.. .. you have to use double
If you know the table names already, this Perl script will dump the tables
into CSV format for you. From there you can build SQL*Loader scripts
to load the data.
For anyone wondering why I didn't just suggest using the Oracle utilities
for migrating from SQL Server to Oracle, it doesn't always
Ferry,
You could dump these tables to a flat file (csv) using SQL Server's DTS and
then use SQL Loader to upload the data into Oracle.
Or
You could use SQL Server's DTS to upload the data directly into Oracle.
You need to create an ODBC connection first to your Oracle DB.
Or
Create a