Problem with function based index on timestamp

From: Björn Wächter <bwc_at_p3-solutions.de>
Date: Thu, 15 Dec 2005 16:49:20 +0100
Message-ID: <40dhmcF19n5uvU1@news.dfncis.de>

Hello all,

I tried to build an index like:

CREATE TABLE A
(

TS TIMESTAMP(3) WITH LOCAL TIME ZONE );

CREATE INDEX IDX_B ON A
(TO_NUMBER(TO_CHAR(TS,'YYYYMMDD')))

LOGGING
NOPARALLEL; SELECT * FROM A; After creating the index I cannot select from the table any more. Looks like there are type conversion problems but why?

I face this problem on Oracle 10g 10.1.0.4

Björn Received on Thu Dec 15 2005 - 09:49:20 CST