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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top