Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to modify the blob size, or how to set the size?

guyupday-1983542Mar 3 2010 — edited Mar 3 2010
i want to know how to modify the blob size, or how to set the size?
what's the default size of blob?

Thanks in advance.

Comments

guyupday-1983542
Blob datatype can contain binary data with a maximum size of 4 GB.
when you enter 10kb file, the database will only use 10kb to store the file (depending on block size etc)
if you want to modify the blob size, you may do like this:

SQL> create materialized view t_mv refresh fast on commit
2 as select id, dbms_lob.getlength(x) len from t;

Materialized view created.

SQL> alter table t_mv add constraint t_mv_chk check (len < 100);

Table altered.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 31 2010
Added on Mar 3 2010
1 comment
1,233 views