Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tilde ~ in index, how to handle

Re: tilde ~ in index, how to handle

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Wed, 18 Sep 2002 13:05:02 +0200
Message-ID: <uognogbd7lga6b@corp.supernews.com>


Use quotation marks:

alter index "abc~0" ...

or in uppercase, if necessary.

Peter

"Uwe Schmidt" <uwe.schmidt_at_dzsh.de> schreef in bericht news:newscache$sypm2h$xgo$1_at_www-neu.dzsh.de...
> 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 ....
>
> Uwe
>
>
>
>
>
>
>
Received on Wed Sep 18 2002 - 06:05:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US