This illustration shows the use case Migrate Long to LOB in the Internal Persistent LOB Interface.

There are two ways to do this. You can:

  1. ALTER TABLE LONG to LOB
  2. COPY long TO Lob using TO_LOB operator