| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CLOB
LOBs can store 4 Gb at max... but I found this information with
contradictions in Oracle Education guides...
As I read:
Writen in a diagram:
"LOB against RAW,LONGRAW: Many columns per table, 4Gb Max size, Select returns locator, Data stored 'in line' or 'not line', ..."
Explanation of the diagram:
"The max size for a LONG is 2Gb, and one LOB can be up to 4Gb..." (?)
Anyway! Lobs are used as "nested extents", so, each one can be a =
segment, if
it's larger than 4000bytes.
So, LOBs have two separated parts: LOB value and LOB locator.
LOBs store the locator in the table, and data in diferent segments, =
except
it's minor than 4000bytes. So, LOBs allow you to store data in separate
segments, tablespaces OR host archive (if we are talking about =
BFILE...)
you have to use the DBMS_LOB package for transactions, and ...
... are you telling that (4000 characters) because of the DESCRIBE =
table
sql*plus command??? :-))
-----Mensaje original-----
De: Alexander I Olefirenko [mailto:bofh_at_rbc.ru]
Enviado el: s=E1bado 4 de noviembre de 2000 8:10
Para: Multiple recipients of list ORACLE-L
Asunto: Re: CLOB
Friday 03 November 2000 16:30, ?????:
> Hi,
>
> All LOBs can store only 4000 chars in line. If you
> have to store more than that then you have to store
> it outside the table in separate tablespace.
>
That are you talking about ?!!!!=20
All LOB's can store up to 4 GigaBytes !
Satya can't you explain in details hw you writing into CLOB
?
may be the problem iz what you can't write more than 4000 byte in one =
time
..
=20
> Johnson
>
> --- "Weiss, Suzanne" <suzanne.weiss_at_intel.com> wrote:
> > I have the same question as Satya below. I don't
> > have the answer saved.
> > Can anybody answer this question again for me, it
> > would be greatly
> > appreciated?
> >
> > TIA.
> > -----Original Message-----
> > From: Satya Gandi [mailto:Satya.Gandi_at_East.Sun.COM]
> > Sent: Wednesday, August 23, 2000 12:07 PM
> > To: oracledba_at_lazydba.com
> > Subject: Re:CLOB
> >
> >
> > Tring to insert more than 4000 characters into the
> > field of CLOB type and
> > got
> > the error
> >
> > ORA-01704 string literal too long
> >
> > Cause: The string literal is longer than 4000
> > characters.
> >
> > Action: Use a string literal of at most 4000
> > characters. Longer
> > values
> > may
> > only be entered using bind variables.
> > ^^^^
> >
> >
> > can anyone help me to overcome this error.
> >
> > Thanks & Regards
> > Satya
> >
> >
> >
> >
> > --------
> > If you're bored, then visit the list's website:
> > http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to
> > oracledba-subscribe_at_quickdoc.co.uk
> >
> >
> >
> > --------
> > Think you know someone who can answer the above
> > question? Forward it to them!
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> > oracledba-subscribe_at_LAZYDBA.com
>
> __________________________________________________
> Do You Yahoo!?
>
> >From homework help to love advice, Yahoo! Experts has your answer.
>
> http://experts.yahoo.com/
--=20
Regards, Olefirenko Alexander
RBC Co. http://www.rbc.ru
Programmer.
(095)935-20-01(207,209)
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Alexander I Olefirenko
INET: bofh_at_rbc.ru
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L Received on Mon Nov 06 2000 - 02:51:07 CST
 |
 |