User gets error message "ORA-00923: FROM keyword not found where expected" when using Duplicate Data function on a table with spaces or double quotes in the column name.
This issue has been reported to the development team and is waiting for fix in future release of Toad for Oracle
Having spaces in column names is not standard Oracle naming convention. Rename the table column names:
1. Right click on the table in the Schema Browser and select "Alter table."
2. Rename the columns and remove any spaces and double quotes from the column name. Click OK.
3. Then run Duplicate Data function again. Rename the columns back after test is complete.