REBUILD INDEX
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: REBUILD INDEX

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    can someone tell me why I go this message when I tried to rebuild an index ????



    Ora-02327: cannot create index on espression with datatype ADT


    Can someone tell me how to fix it ???




  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    02327, 00000, "cannot create index on expression with datatype %s"
    // *Cause: An attempt was made to create an index on a non-indexable expression.
    // *Action: Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.

    //02328, 00000, "REF column cannot be specified on VALUE ADT"
    // *Cause: attempt to create REF column of VALUE ADT
    // *Action: remove REF specifier from column specification




    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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