Re: tilde ~ in index

Uwe Schmidt wrote:

> Hey Newsgroup,
>
> i would like to change the storage parameter for an index like abc~0,
> but if i try to do so:
>
> alter index abc~0 storage (maxextents 300);
> invalid character
>
> ...................."abc~0" .................
> index not found
>
> ....................'abc~0'
>
> What have I to do ????
>
> Thanks a lot ....

Try ALTER INDEX "abc~0"

Also try renaming your indexes to something that have actual meaning. I would never allow anyone to name objects as you have. An index name should, at a minimum, contain a code indicating the type of index and the purpose or columns on which the index is placed.

Daniel Morgan Received on Wed Sep 18 2002 - 17:44:31 CEST