Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What is the Oracle 8i Lob Default Initial Extent Size?

What is the Oracle 8i Lob Default Initial Extent Size?

From: Brian Grosheim <bgrosheim_at_medplus.com>
Date: Mon, 06 Dec 1999 22:17:20 GMT
Message-ID: <384c3510.533721110@news.one.net>


I can easily create a lob in one of my tables by using the following command:

alter table class add (batch_scanner_settings clob) lob (batch_scanner_settings) store as (enable storage in row)

However, unless I add a datafile to my tablespace, I get the folloing error:

ORA-01658: unable to create INITIAL extent for segment in tablespace DEFINITION_DATA How can I determine how big the Initial extent will be when creating the CLOB? Received on Mon Dec 06 1999 - 16:17:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US