Data Result Set | Export option to export to an Excel file only allows up to 65000 records to be exported.Excel 2007 has expanded this limit to overone million rows.
WORKAROUND:
1. Save the export in SQL Navigator as a Delimited text format (.csv).
2. Open the .csv file in Excel and use the Excel Text Import feature.
3. Run the wizard to import all data to an Excel format file.
Alternatively, a .csv file may be just saved as an .xlsx file, but it's preferred to use the wizard for further options.
STATUS:
This issue is fixed in SQL Navigator for Oracle 7.0. This version can be downloaded at https://support.quest.com/softwaredownloads.aspx?pr=268435514&pv=4294946839.
