OraFAQ Forum: Server Administration » Space allocation for moving the LOB segment to different tablespace

Home » RDBMS Server » Server Administration » Space allocation for moving the LOB segment to different tablespace

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

Space allocation for moving the LOB segment to different tablespace [message #332145]

Mon, 07 July 2008 11:17

shrinika
Messages: 306
Registered: April 2008

Senior Member

Hello,

I am trying to move the LOB segment from one tablespace to another tablespace. Currently, the LOB is residing in table tablespace. It is stored with all other columns. I want to move to different tablespace.

Now I need to create a separate tablespace and allocate the data file. The issue here is, I have only less space in production. I wanted to allocate the right space for LOB tablespace. I do not want this moving operation fail due to insufficient space for LOB tablespace.

The LOB column name is WEB_BODY. So here is I am running two queries and little bit confused.

SQL> select sum(length(web_body))/1024/1024/1024  SIZE_IN_GB
  2   FROM BODY_CONTENT where web_body is not null;

SIZE_IN_GB
------------------------------
                    33.3610248


SQL> select sum(bytes)/1024/1024/1024 FROM DBA_SEGMENTS
  2  where owner='INVENT' and segment_name='BODY_CONTENT;

SUM(BYTES)/1024/1024/1024
-------------------------
               .172851563

Any help appreciated...

[Updated on: Mon, 07 July 2008 11:18]

Report message to a moderator