Anybody have any experiences moving tables with LOBS from one db to another ? Pre-import table creation and import with ignore=y seems do not work for me. I have tables with CLOBS to be moved.. (internal LOBS only)
*COPY command doesn't work, SQL*Plus crashed for me when I tried.
*CTAS doesn't work as there needs to dblink and LOBS are not supported over dblinks.
Is there any easy of doing it ? other than creating the table with LOB on target database and inserting the data with SQL*PLus inserts.