Showing posts with label LOBs. Show all posts
Showing posts with label LOBs. Show all posts
Thursday, June 17, 2021

How to list partitions and their LOB segment sizes

›
SELECT ts.table_owner "owner", ts.table_name "table name", s.SEGMENT_NAME "segment name", ...
Thursday, November 14, 2019

How to move XML LOB segments in a partitioned table to a new tablespace

›
The examples used in this article is based on Oracle 18c. When moving a partition with XMLTYPE columns to a new tablespace, the LOB obje...
Friday, November 8, 2019

How to list subpartitions and their LOB segment sizes

›
The query below will list the lob segment names, the lob subpartition names, the table subpartition names and sizing information for any ...
Wednesday, August 30, 2017

What exactly is a LOB index object?

›
This question was answered by Tom Kyte in an old post from 2001. A LOB is simply a pointer. It points to an index. The index points to t...
Wednesday, August 31, 2016

How to list table sizes and their LOB segment sizes

›
Sometimes a quick sum of the used bytes in DBA_SEGMENTS is not enough to find the total size of a table. If you have Large Object type col...
3 comments:
Monday, December 29, 2014

How to move LOB segments in a sub-partitioned table to a new tablespace

›
Find the sub-partitions that you would like to relocate: SELECT TABLE_OWNER,TABLE_NAME,COLUMN_NAME,LOB_NAME,SUBPARTITION_NAME,LOB_PARTI...

How to move LOB segments in a partitioned table to a new tablespace

›
During an attempt to move a partition that contained a LOB segment from one tablespace to another, I hit the infamous ORA-14511 "Canno...
1 comment:
Monday, October 21, 2013

How to move a table containing LOB columns to a new tablespace

›
Find out which tables have LOB objects: SELECT TABLE_NAME,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME,INDEX_NAME FROM DBA_LOBS WHERE ...