Forum Stats

  • 3,733,973 Users
  • 2,246,852 Discussions
  • 7,856,957 Comments

Discussions

Unable to create Index on mixed case columns

user7687595
user7687595 Member Posts: 7
edited May 2015 in SQL

We have the below table structure where the columns are in mixed cased and I have to create a composite index as given below:

TABLE1

Col1 NUMBER(10,0),

Col2 NUMBER(10,0),

COL3 VARCHAR2(10)

Note: Col1 & Col2 are mixed case.

When I try to create the below index:

CREATE INDEX idx1 ON TABLE1 ("Col1","Col2") COMPRESS 3 COMPUTE STATISTICS;

I am getting the below error. Please let me know what is the way to resolve this error.

Error report:
SQL Error: ORA-00911: invalid character

00911. 00000 - "invalid character"

*Cause: identifiers may not start with any ASCII character other than

letters and numbers. $#_ are also allowed after the first

character. Identifiers enclosed by doublequotes may contain

any character other than a doublequote. Alternative quotes

(q'#...#') cannot use spaces, tabs, or carriage returns as

delimiters. For all other contexts, consult the SQL Language

Reference Manual.

*Action:

Sign In or Register to comment.