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!

Error ORA-01489 while creating MV

N_RajOct 5 2017 — edited Oct 5 2017

Hi All,

we have oracle db 11.2 on aix. The db_block_size is 8192

While creating MV,we got the error ORA-01489 Result of string concat is too large

It is a clob column.

If i want to store more than 4 GB data,which datatype suits for that.

I read this link "https://docs.oracle.com/cd/B19306_01/server.102/b14237/limits001.htm#i287903"

For CLOB says that Initialization parameter (8 TB to 128 TB).

Anyone please explain the above line .what does it mean?

Any suggestions

Thanks & Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2017

Added on Oct 5 2017

#general-database-discussions

12 comments

231 views