We have recently upgraded from 8.0 to 9.7.2. One of our regular processes involves exporting the contents of approx 50 tables to EXCEL files
In TOAD 8.0, one EXCEL file was created for each table. Howerver, under 9.7.2, EXCEL files are only created for tables which actually contain data. In addition, a warning message is displayed for each table which is empty.
Is there a way for TOAD to create the EXCEL file even if the table is empty? I’ve looked through all of the various ‘TOAD Options’, but can’t find anything obvious. I’ve also tried saving as different file types, but TOAD sill won’t create the export file if the ORACLE table is empty.