Functional indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Functional indexes

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    Red face

    when I try to create the following index I get

    CREATE INDEX TEST.fn_idx_date_to_epoch
    ON bob.test1 (TRADETIME, TRADEDATE, surv_epoch.date_to_epoch(tradedate,tradetime)))
    TABLESPACE DATA

    i get an ORA-02158: invalid CREATE INDEX option

    Any ideas?
    Share on Google+

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You seem to have too many ) in that statement

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width