Just realized today that some of my automations are failing. Two issues here:
- Not getting the srcipt error email
- They are failing at the export step.
I noticed this also in manual exports of select * from table. I often get this
ORA-01741: illegal zero-length identifier Export is cancelled
To work around this, I export table and select the table to export, but several
of my automations use a select * from table to export the entire table. These
are all failing.