Alter Table Move LOB to Another Tablespace
Move 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
Binary Large Object (BLOB)
How to Check Oracle Segment Size
Find 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 ?
Sometimes, 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 ?