ORA-01735: invalid ALTER TABLE option – Toad
In TOAD I suppose, you need to execute it as a script (press F5) rather that running it as a statement.
toad
Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
Just use multiple in-clauses to get around this: