3 Replies Latest reply: Jan 2, 2014 6:39 AM by user713408 RSS

ORA-33674: Data block exceeds the maximum size of 100 bytes

Usman80 Newbie
Currently Being Moderated

DB: 11.1.0.7

 

We are experiencing the following error when querying data from the dimension view. The data gets loaded into dimension without any problem.

 

ORA-33674: Data block exceeds the maximum size of 100 bytes.

33674. 00000 -  "(FTCODE00) Data block exceeds the maximum size of %d bytes."

*Cause:  

*Action:

 

I have searched this forum and looked at bug 7579305 and note 751511.1 but it does not seem to apply to our case. I have already increase the attribute size to 200 (max length of data in our case is 196). I even tried to reduce the size of data loaded into the dimension to only 50 characters but still the same problem (although this time the error occurred on a different row). We have international characters in our data and there are about 64,000 rows in the dimension. Not sure that if matters. Any help is appreciated.

 

Thanks,

Usman

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points