How to create table with default DATE column using { ts }?
Whatever syntax that is, that is not correct in Oracle.

Use this:

create table my_table ( 
    transaction_date DATE DEFAULT timestamp'1900-01-01 00:00:00' NULL 
);