In Toad 2025 R2, when exporting data from the Editor | Data Grid to Insert Statements, the table data is not included in the script, if "Detect Automatically" is unticked.
Steps:
1. In the Editor, run a select statement.
2. In the Data Grid results, click the 'Export Data' button in the toolbar.
3. Set the export settings to Insert Statements, ensure to change the name of the schema and table at the bottom, and then ensure "Detect Automatically" is unticked
4. Enter some alternate schema and table names
5. When you click Export, there may be an error: 'No table name specified'
But if there is no error, the script still doesn't include the updated table or schema name that is specified in the export data form, e.g:
SET DEFINE OFF;
Insert into SCHEMA.ORIGINAL_TABLE_NAME
(ID, NAME)
Values
(2, 'test');
COMMIT;
In 2025 R1, this issue doesn't occur, and the statement would look like:
SET DEFINE OFF;
Insert into NEW_SCHEMA.NEW_table_name
(ID, NAME)
Values
(2, 'test');
COMMIT;
Defect. The "Detect Automatically" option in the Export Data window, when unchecked, doesn't use what's in the edit boxes.
WORKAROUND 1:
You can use an older version of Toad installed side by side, where the issue doesn't exist.
WORKAROUND 2:
1. Run "select * from table" and export that to insert statements, leaving the "Detect Automatically" option switched on.
2. You may have to do a search/replace on "table name" in the script manually, to change it to the required details.
STATUS:
Issue fixed in Toad for Oracle 2025 R2
The latest version of Toad for Oracle can be downloaded here:
Windows
Mac
