I have a database that is 3,5 GB in a single table.
I tried to change some indexes in this database and as result I got a message:
ISC ERROR CODE:335544373
ISC ERROR MESSAGE:
operating system directive CreateFile failed
The system cannot find the path specified.
CREATE ASC INDEX I_MON_OID_VARIABLE_1 ON MON_OID_VARIABLE (DEVICEID, OIDFK, OIDINDEX, OIDTIMESTAMP)
The reason is that my temporary folder points to RAM drive that has only 500MB free and probably for this index more then 500MB is needed.
In this case I think more appropriate message is required.