Home » RDBMS Server » Server Administration » I can't insert CLOB data large than 4k.
I can't insert CLOB data large than 4k. [message #369248] Wed, 26 July 2000 02:16 Go to next message
Joseph Lee
Messages: 3
Registered: July 2000
Junior Member
I have a table including CLOB datatype. I can normally insert data less than 4k, but i can't insert data large than 4k. Can you help me?

TIA

Report message to a moderator

Re: I can't insert CLOB data large than 4k. [message #369275 is a reply to message #369248] Mon, 31 July 2000 10:54 Go to previous message
Mark Johnson
Messages: 5
Registered: August 1999
Junior Member
Varchar2 columns have either a 2K (Oracle7) or 4K (Oracle 8i) limit. RAW is the same as varchar2 on size limits. LONG columns have a 2GB limit. CLOB columns can store 2GB or 4 GB depending on which version of Oracle you are using.

Report message to a moderator

Previous Topic: v$log: status : ACTIVE ?
Next Topic: How to retrieve current partition position
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 06:04:13 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.