SQL & PL/SQL

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!

Non unique addressing in MODEL dimensions?

896983Nov 15 2012 — edited Nov 19 2012

Hello all,

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Req:

I have a field with duplicate words like 'PRESIDENT;PRESIDENT-EXECUTIVE;PRESIDENT' ( seperated by semicolon) I need to remove duplicate words from a line. I have like 1Million rows to work on...

ORA-32638: Non unique addressing in MODEL dimensions
32638. 00000 -  "Non unique addressing in MODEL dimensions"
*Cause:    The address space defined for the MODEL (partition by and dimension by
           expressions) do not uniquely identify each cell.
*Action:   Rewrite the MODEL clause. Using UNIQUE SINGLE REFERENCE
           option might help.

First time i am using Model Dimension by

SELECT   BIO, RTRIM (str_new, ';') new_str
  FROM   db_temp
MODEL
   DIMENSION BY (0 dim)
   MEASURES (BIO, BIO || ';' STR_NEW)
   RULES
      ITERATE (1000) UNTIL (STR_NEW[0] = PREVIOUS (STR_NEW[0]))
      (str_new [0] =
            REGEXP_REPLACE (str_new[0], '(^|;)([^;]+;)(.*?;)?\2+', '\1\2\3'));

Any Better approach to handle this type of situation other than Model Dimension by

This post has been answered by odie_63 on Nov 15 2012

Jump to Answer

mwrf

resolved, just being stupid.

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2012

Added on Nov 15 2012

3 comments

3,793 views

SQL & PL/SQL

Non unique addressing in MODEL dimensions?

Comments

Post Details