Problem solve Get help with specific problems with your technologies, process and projects.

Exporting with LOBs

An Oracle user asks how to make sure LOBs get exported when doing a schema level export.

I am doing a schema level export ( 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.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.