Return
-
Title
Error "ORA-00923: FROM keyword not found where expected" when using Duplicate Data function on -
Description
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.1. Create a table with spaces in column name such as:CREATE TABLE TEST
(
"Workstation" NVARCHAR2(50),
"Keycode" NVARCHAR2(80),
"User or Company (?) " NVARCHAR2(58),
"Add-Ons" NVARCHAR2(104),
"Keyfile path" NVARCHAR2(147)
)2. In Schema Browser, right click on table, click on Duplicate Data
3. Click on the Duplicate Data (Summary) tab and you'll get the error.
Error occurs because Toad runs the following query which is invalid:
Select Workstation, Keycode, User or Company (?) , Add-Ons, Keyfile path
, count(*) as Occurrences
from TEST
HAVING count(*) > 1
group by Workstation, Keycode, User or Company (?) , Add-Ons, Keyfile path
4. The error does not occur if the table has no spaces, such as the following table:CREATE TABLE TEST2
(
WORKSTATION NVARCHAR2(50),
KEYCODE NVARCHAR2(80),
USERORCOMPANY NVARCHAR2(58),
ADDONS NVARCHAR2(104),
KEYFILEPATH NVARCHAR2(147)
) -
Resolution
STATUS:
This issue has been reported to the development team and is waiting for fix in future release of Toad for Oracle
WORKAROUND:
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.
-
Defect ID
ST79875