Home » RDBMS Server » Server Administration » Space allocation for moving the LOB segment to different tablespace
Space allocation for moving the LOB segment to different tablespace [message #332145] Mon, 07 July 2008 11:17 Go to next message
shrinika
Messages: 267
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

Re: Space allocation for moving the LOB segment to different tablespace [message #332218 is a reply to message #332145] Mon, 07 July 2008 23:30 Go to previous message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Hi,
Find the SEGMENT_NAME for the LOB table from DBA_LOBS and find the corresponding size of the segment from DBA_SEGMENTS.

[Updated on: Mon, 07 July 2008 23:32]

Report message to a moderator

Previous Topic: installation
Next Topic: BreakUnbreak Oracle Jobs
Goto Forum:
  


Current Time: Sun Dec 11 06:24:49 CST 2016

Total time taken to generate the page: 0.07636 seconds