I want to export a subset of data from a table that is extremely large. The table is partition by a number that represents the yyyymm that the data was entered. I created the Query Iterator(yearMonthQry) that selects the distinct yearMonth from the table. Then I want to create the export dataset from the same table by using the %yearMonthQry.yearMonth% in the where clause and also in the naming convention of the file that is generated. I looked at example for creating the Excel spreadsheet with the variables in the file name. When running this, I get the ORA-00911: invalid character message. I would appreciate any help or insight where I went wrong. I have Toad for Oracle 12.11.
Thanks.