Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02327: cannot create index on expression with datatype LOB

827207Oct 4 2011 — edited Oct 4 2011
Hi,

I am creating index with below command:- in oracle 9i window 2000 server

Create index sysadm.X_TEXT_FILE_ATTACHMENTS on SYSADM.PR_ADDTL_DATA (LS_VALUE);

SQL> Create index sysadm.X_TEXT_FILE_ATTACHMENTS on SYSADM.PR_ADDTL_DATA (LS_VAL
UE) tablespace USERS;
Create index sysadm.X_TEXT_FILE_ATTACHMENTS on SYSADM.PR_ADDTL_DATA (LS_VALUE) t
ablespace USERS
*
ERROR at line 1:
ORA-02327: cannot create index on expression with datatype LOB

Please help me to find out the solution.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2011
Added on Oct 4 2011
#general-database-discussions
9 comments
3,782 views