Version: 17.0.0-alpha-1
Build #: 45030
Build Date: 2015-Aug-02 09:25:07 AM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=281,542,656; Free=129,859,752; CPUs=8
Steps to reproduce:
Connect to SAPHANA
Create table using following script:
CREATE TABLE "Lob_type" (
"c1" BLOB MEMORY THRESHOLD 1000,
"c2" CLOB MEMORY THRESHOLD 1000,
"c3" NCLOB MEMORY THRESHOLD 1000
)
UNLOAD PRIORITY 5
GO
Right click on Lob_type table in tree node-> click on ALter Table
Go to column c1,c2 and c3 in Alter table window and go to their column properties
Memory Threshold option is disabled in Alter table window
Execute following script for Alter the Memory Threshold option:
ALTER TABLE "Diksha"."Lob_type" ALTER ("c1" BLOB MEMORY THRESHOLD 500)
GO
ALTER TABLE "Diksha"."Lob_type" ALTER ("c2" CLOB MEMORY THRESHOLD 500)
GO
ALTER TABLE "Diksha"."Lob_type" ALTER ("c3" NCLOB MEMORY THRESHOLD 500)
GO
Expected Result: Memory Threshold option should be enable in Alter table window.
Memory Threshold is no modifiable for Blob, Clob, NClob datatypes. Added scripting support for the alter.