PROTECTED]
cc:
Subject:Importing SQL 7.0 tables
I need to import into Oracle my SQL 7.0 tables.
How could I complete this?
Thanks,
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
FILE;
}
$dbh-disconnect;
Ferry Situmorang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/02 08:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Importing SQL 7.0 tables
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
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Importing SQL 7.0 tables
I need to import into Oracle my SQL 7.0 tables.
How could I complete this?
Thanks,
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
I need to import into Oracle my SQL 7.0 tables.
How could I complete this?
Thanks,
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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