I am doing a schema level export (220.127.116.11) for archiving a schema, and there are LOBs (CLOBS and BLOBS) in some of the tables. The export completes without any problems, but the DMP file size is 80 MB, while some of the LOB files are easily over 500 MB, clearly indicating that they are not being exported. Can you tell me if there's a way to make sure the LOBs get exported?
The best way to make sure the data is getting exported is to import from the dump file! Create a test user (I'll call it BOB) and then import from the original user (I'll call it SCOTT) into the test user.
imp userid=system/manager file=my_dmp.dmp log=imp.log fromuser=scott touser=bob
After the import completes, verify if the LOBs are present in the BOB schema. If they are, then you know the dump file contains the LOBs.
This was first published in February 2008