Importing from csv to Oracle timestamp
===

I have a column in a csv file called `created` with values:

    2012-04-16 14:46:42
    2012-06-16 12:40:52.653000000

I am trying to import this into Oracle 11gR2 with SQL Developer 3.1.07

I am using this as a format: `RRRR-MM-DD HH24:MI:SS.FF`

I get error `input value not long enough for the date format`

If I change the format to `RRRR-MM-DD HH24:MI:SS` I get error `SQL Error: ORA-01830: date format picture ends before converting entire input string`

How should I do it?