Oracle Database Discussions

Hello,

Oracle Version: Oracle Database 11g Release 11.1.0.6.0 - 64bit
OS Version: Microsoft Windows Server 2003 R2, Enterprise x63 Edition

I am trying to export only Materialized views from certain schema using the below command. Will it work?

expdp 'sys/XYZ@ABC as sysdba' schemas=USER1 INCLUDE=MATERIALIZED_VIEW directory=data_pump_dir dumpfile=expdp_USER1_MAT_VIEW_ONLY.dmp logfile=expdp_USER1_MAT_VIEW_ONLY.log

I tried this and here is the output:

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_SCHEMA_01": 'sys/********@ABC AS SYSDBA' schemas=USER1 INCLUDE=MATERIALIZED_VIEW directory=data_pump_dir dumpfile=expdp_USER1_MAT_VIEW_ONLY.dmp logfile=expdp_USER1_MAT_VIEW_ONLY.log

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
C:\DP_EXP_IMP_DIR\expdp_USER1_MAT_VIEW_ONLY.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 08:36:00

This doesnt seem correct to me. Can anyone suggest me where did I go worng.

Thanks in advance.