Data Migration from Oracle (Data Import)

Extensibility

Data Migration from Oracle (Data Import)

Dear All

I have just registered to Teradata forum and very new. If my question is posted under wrong section sincere apologies.

In one of our current project data is extracted from 1200 source tables (Residing on Oracle 10G), data is extracted using Oracle Data_Pump + PLSQL into a dump file (.dmp or .exp) and imported into Oracle Target 1200 tables using Oracle PLSQL. Just an overnight CDC from source. No transformation of Data.

We do have intentions to move our Target across to Teradata. When this happens,

Question: Can Teradata utilities read contents from Oracle (.dmp or .exp) file which is binary format in import data to target tables residing on Teradata?

5 REPLIES
Teradata Employee

Re: Data Migration from Oracle (Data Import)

Sorry, Kris, but Teradata can not read .dmp or .exp files. There is a toolkit available from Teradata that will migrate tables from Oracle to Teradata via TPT (teradata parallel transporter). It is called ora2td. Your Teradata rep can get it for you.
N/A

Re: Data Migration from Oracle (Data Import)

If the size of your Oracle Data is not too big, alternatively you can use open source ETL tool ( Kettle-Spoon ), its fast and easy, read from Oracle DB and write directly to Tearadata tables avoiding any intermediate stage.
Teradata Employee

Re: Data Migration from Oracle (Data Import)

Hi,

ETL tool can be a good option if possible in your case .... otherwise .... search for Data-Direct Connector and/or GoldenGate Data Connector .... they might also be used in your case.

Regards, MAC

Re: Data Migration from Oracle (Data Import)

You can also import data from the oracle to teradata by using DATA STAGING...

Re: Data Migration from Oracle (Data Import)

Hi everyone,

If we will use Ora2TD for data migration, will it create tables also on teradata platform? Or it will only load the data?

If not can anyone please suggest which tools we can use for data migration which will include creation of oracle tables on teradata database, creation of corresponding indexes and partitions, data type conversions and data loading.

Please suggest.
Thanks in advance.