Sql – Direct Path Load of TimeStamp Data With SQL*LDR

oraclesql-loader

The SQL-LDR documentation states that you need to do a convetional Path Load:

When you want to apply SQL functions
to data fields. SQL functions are not
available during a direct path load

I have TimeStamp data stored in a CSV file that I'm loading with SQL-LDR by describing the fields as such:

STARTTIME       "To_TimeStamp(:STARTTIME,'YYYY-MM-DD HH24:MI:SS.FF6')",
COMPLETIONTIME  "To_TimeStamp(:COMPLETIONTIME,'YYYY-MM-DD HH24:MI:SS.FF6')"

So my question is: Can you load timestamp data without a function, or is it the case that you can not do a Direct Path Load when Loading TimeStamp data?

Best Answer

Here is an example of someone successfully direct loading timestamp data:
Loading Data (Part 4): sqlldr (direct, skip_index_maintainance)

Related Topic