OraFAQ Forum: Server Administration » Allocating extent to a clob column of a table!

Home » RDBMS Server » Server Administration » Allocating extent to a clob column of a table! (10.2.0.4 on Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Allocating extent to a clob column of a table! [message #487697]

Thu, 30 December 2010 02:34

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi experts

I have a table with two clob columns and need to manually allocate space to the table and to its lob segment. Is the following command correct?

--to allocate extent to the table
alter table emp allocate extent;
--the table has columns named col1 and col2 which are clob
--to allocate extents to the columns 
alter table emp modify lob (col1) (allocate extent (size 10m))
/ 
alter table emp modify lob (col2) (allocate extent (size 10m))
/

Thanks

Report message to a moderator

Re: Allocating extent to a clob column of a table! [message #487699 is a reply to message #487697]

Thu, 30 December 2010 02:45

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why don't you try it?

SQL> alter table emp modify lob (col1) (allocate extent (size 10m))
  2  / 

Table altered.

SQL> alter table emp modify lob (col2) (allocate extent (size 10m))
  2  / 

Table altered.

SQL> 
SQL> alter table emp allocate extent;

Table altered.

Regards
Michel

Report message to a moderator