Re: tilde ~ in index, how to handle

Uwe Schmidt wrote:

> alter index abc~0 storage (maxextents 300);
> invalid character

Oh yeah - or else if the name is correct with that tilde, then wrap the index name into double quotes, i.e.
alter index "abc~0" storage (maxextents 300);

If the index name is caps, then:
alter index "ABC~0" storage (maxextents 300);

--
Billy