Alter Table Move LOB to Another Tablespaceby Ed ChenDecember 6, 2021March 23, 2023Move LOB Segment Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to… Read More »Alter Table Move LOB to Another Tablespace
How to Check Oracle Segment Sizeby Ed ChenJanuary 14, 2019December 10, 2022Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »How to Check Oracle Segment Size
Oracle Lob Segment Belongs to Which Table ?by Ed ChenJanuary 11, 2019November 23, 2023Sometimes, you may see segment type like LOBSEGMENT in the top 10 segments list. They are Large Object (LOB) which may be Binary Large Object… Read More »Oracle Lob Segment Belongs to Which Table ?