Materialized Views Created in Version 8 are Not Exported Using Datapump Or Traditional Export (Doc ID 1602534.1)

Last updated on FEBRUARY 23, 2024

Applies to:

Symptoms

Certain materialized views (MV) were not exported.

Same behaviour with datapump and with traditional export.

When trying to export such an MV directly, then the following error occurs:

expdp ... schemas=DMS include=MATERIALIZED_VIEW:"IN('STOP_DRUG')" ...

oracle@usehux336:/u50/migration/BP22/ [BP22] cat BP22_sdmvs.log
;;; 
Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 14 November, 2013 14:12:45

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
Starting "MIGTMP"."SYS_EXPORT_SCHEMA_01":  migtmp/******** directory=dpexp schemas=DMS include=MATERIALIZED_VIEW:IN('STOP_DRUG') parallel=4 dumpfile=BP22_sdmvs.dmp logfile=BP22_sdmvs.log 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema DMS was not found.
ORA-39168: Object path MATERIALIZED_VIEW was not found.
ORA-31655: no data or metadata objects selected for job

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.