migrate data from oracle to teradata

Tools

migrate data from oracle to teradata


I am new to the teradata trying to migrate data from oracle to teradata.

the data in oracle is in table with the following structure

SQL> desc O10;
Name Null? Type
----------------------------------------- -------- -------------------------
O10_ID NOT NULL NUMBER(10)
O10_FLOAT NOT NULL FLOAT(126)
O10_NUMBER1 NOT NULL NUMBER
O10_NUMBER2 NOT NULL NUMBER(20)
O10_NUMBER3 NOT NULL NUMBER(20,2)
O10_DATE NOT NULL DATE
O10_CHAR NOT NULL CHAR(10)
O10_VARCHAR2 NOT NULL VARCHAR2(100)
O10_LONG NOT NULL LONG
O10_NCHAR NOT NULL NCHAR(10)
O10_NVARCHAR2 NOT NULL NVARCHAR2(100)

First I used oracle sqlplus to generate data file
then I used fastload tool to load data and come out load script but seems not working.
Something must be wrong.

1. the format specified in sqlplus is ok?
2. did I map the correct data types between oracle and teradata?
3. how fastload can work on variable-length data type,like nvarchar,varchar?
4. what would be the best approach to handle this migration?

I would appreciate any help from someone with this kind of experience.
Regards,
P.C.

sqlplus script
=================
set echo off
set newpage 0
set pagesize 0
set space 0
set feedback off
set heading off
set linesize 2500

spool O10.txt

SELECT
O10_ID
,O10_FLOAT
,O10_NUMBER1
,O10_NUMBER2
,O10_NUMBER3
,TO_CHAR(O10_DATE,'YYYY/MM/DD')
,O10_CHAR
,O10_varchar2
,O10_LONG
,O10_NCHAR
,O10_NVARCHAR2
FROM O10
/
=========================
load script:
=========================
SHOW VERSION;
SESSIONS 2;
ERRLIMIT 25;

LOGON xxx/xxx,xxx;

DATABASE xx,

DROP TABLE O10;
DROP TABLE O10_ERR1;
DROP TABLE O10_ERR2;

CREATE TABLE O10 (
O10_ID INTEGER,
O10_FLOAT FLOAT,
O10_NUMBER1 INTEGER,
O10_NUMBER2 INTEGER,
O10_NUMBER3 FLOAT,
O10_DATE DATE FORMAT 'YYYY/MM/DD',
O10_CHAR CHAR(10),
O10_VARCHAR2 VARCHAR(100),
O10_LONG VARCHAR(2000),
O10_NCHAR CHAR(30),
O10_NVARCHAR2 VARCHAR(300))
UNIQUE PRIMARY INDEX(O10_ID);

SET RECORD UNFORMATTED;

DEFINE ====> do I have to specify fix length for various data types?

O10_ID (CHAR(10)),
O10_FLOAT (CHAR(126)),
O10_NUMBER1 (CHAR(5)),
O10_NUMBER2 (CHAR(20)),
O10_NUMBER3 (CHAR(22)),
O10_DATE (CHAR(20)),
O10_CHAR (CHAR(10)),
O10_VARCHAR2 (CHAR(100)),
O10_LONG (CHAR(2000)),
O10_NCHAR (CHAR(30)),
O10_NVARCHAR2 (CHAR(300)),
WINDOWS_EOR_CHARS (CHAR(2))

FILE=O10-1.txt;

SHOW;

begin loading O10
errorfiles O10_ERR1, O10_ERR2;

INSERT INTO O10 VALUES (
10_ID,
10_FLOAT,
10_NUMBER1,
10_NUMBER2,
10_NUMBER3,
10_DATE,
10_CHAR,
10_VARCHAR2,
10_LONG,
10_NCHAR,
10_NVARCHAR2
);

end loading;
LOGOFF;
===========================================