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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: