Re: Weird Indexname

The ability to have mixed case object names and also the ability to have spaces and special characters in an object name created using double quotation marks is a feature. Where are you issuing the

      create index "agenda$alarmdate" on agenda(alarmdate);

statement? Have you tried

      create index agenda$alarmdate on agenda(alarmdate);

The shell should not try to resolve $alarmdate when you issue the command in SQL*PLUS.

                               Ian MacGregor
                               Stanford Linear Accelerator Center
                               (415) 926-3528