'ORA-00922 missing or invalid option' error in Exadata 18c, when running a create tablespace script with option DEFAULT TABLE COMPRESS FOR QUERY HIGH (4245332)

'ORA-00922 missing or invalid option' error in Exadata 18c, when running a create tablespace script with option DEFAULT TABLE COMPRESS FOR QUERY HIGH

In an Exadata 18c environment, if you create a tablespace with option DEFAULT TABLE COMPRESS FOR QUERY HIGH, if you go to the Database Browser and select this tablespace and the Script tab, then take this script and paste it in the Editor, it shows a syntax error and the execution fails with the error 'ORA-00922 missing or invalid option' because of the additional phrase COLUMN STORE added to the script.

DBMS_METADATA does not show this phrase.

WORKAROUND:
Issue resolved in the latest Toad for Oracle Beta version (13.2.0.16 or later), available to download from here

STATUS:
Waiting for fix in a future release of Toad for Oracle

TOR-3251