Oracle Large Object Data Types (LOB) | Oracle SQL fundamentals

LOB stands for Large Object, a stream of #data stored in a #database. Maximum capacity of a LOB is (4 gigabytes-1) bytes. In #Oracle three kinds of #LOB data type exist: #BLOB datatype stores unstructured binary large objects.
LOB is large object byte used to store large amount of data. The following types come under LOB data types:
#CLOB and #NCLOB can both be used to store 4 GB of data in the database.

[jacobhamfeldtkold]

What do you get out of storing a path to a file in the BFILE data type instead of just storing the path as a VARCHAR. (string)

[RizaGunturPrakoso]

avoid LOB if possible since it is not supported by Oracle Golden Gate 19c. Check compatibility before using LOB