I have an Oracle Spatial table.
I would like to make another identical table with a different name.
I do a describe on the table and get the popup.
Clicking on the Scripts tab and returning the table source SQL, I pasted it into a SQL window.
I change the table name and execute script and generate the error:
"ORA-22917: use VARRAY to define the storage clause for this column or attribute".
WORKAROUND:
In the script creation options (the View / Edit Script options icon), uncheck the option to include the storage clause (Storage Objects Tab | Uncheck Storage Clauses) .
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy