How you load the date records from oracle to teradata table without casting into date format.
Is it possible for you to look into INMOD option? Or can you load the TIMESTAMP such as "12-07-2011:23:58:23" as VARCHAR(19) and then process using SQL?
You can load timestamp field to Teradata using fastload only if the data file has the timestamp format "YYYY-MM-DD HH24:MI:SS". Try extracting your data into this format from Oracle. You can set NLS_TIMESTAMP_FORMAT setting in Oracle so it produces the timestamp in this format.