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
Character Large Object (CLOB)
How to Modify VARCHAR2 to CLOB of a Column
Data Type Conversion There're several major data types built in Oracle. Character Numeric Datetime LONG RAW LOB (Large Object) In each major data types, minor… Read More »How to Modify VARCHAR2 to CLOB of a Column
How Oracle Search View Text in ALL_VIEWS
ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »How Oracle Search View Text in ALL_VIEWS
How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG
ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG
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 Find LOB Segment 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 Find LOB Segment Table