Export DIRECT=Y with LOB data under 8.0.4/8.0.5

Hi everyone,

Each night we do a full export of our database using direct=Y and because of the presence of Oracle Advanced Queuing (Oracle AQ) tables containing LOB data we run into this error.

EXP-00067: "Direct path cannot export %s which contains object

           or lob data."
    Cause: Direct path export cannot export tables that contain

           LOBs, files, or object datatypes.    Action: Use conventional path export to export tables containing

           these datatypes.

Enhancement request 621301 has been filed with Oracle WWS.

Since these tables contain LOB data a direct path export will fail. Conventional export takes to long during our maintenance window. We only do the export to check for datablock corruption and we do not use the dump file for recovery purposes.

I have found a workaround to this problem by inserting other tables (application specific tables containing lob data) into the sys.noexp$ table.

Oracle recommend that you modify the export views (page 429 Oracle 8 DBA Handbook) to include tables you do not want to export. That sounds to a bit messy.

Does anyone have a reason why you should not insert into the sys.noexp$ table?
I know that the general rule is you shouldn't but is there any implications in doing this on this specific table?

I have spoken to Oracle WWS and they have not been able to provide a definitive answer to this question.

Oracle recommend that the AQ tables be dropped if you are not using AQ option. Although the developers are looking at using the AQ option in the not to distant future.

TIA Regards

Roger Jackson Received on Wed Apr 21 1999 - 06:28:24 CDT