expdp showing ORA-31655
653212Jan 19 2010 — edited Jan 19 2010Hi,
whenever i tried to export using expdp i got ORA-31655.
Please find detail snapshot below:
$ expdp TABLESPACES=DP_TEST file=data_expdp.dmp directory=DMP_DIR;
Export: Release 11.2.0.1.0 - Production on Tue Jan 19 16:30:26 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: sys@MYDB as sysdba
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=data_expdp.dmp" Location: Command Line, Replaced with: "dumpfile=data_expdp.dmp"
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYS"."SYS_EXPORT_TABLESPACE_01": sys/********@MYDB AS SYSDBA TABLESPACES=DP_TEST dumpfile=data_expdp.dmp directory=DMP_DIR reuse_dumpfiles=true
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLESPACE_01" completed with 1 error(s) at 16:30:42
The same command is working file in another(fresh 11.2.0.1) database
We have just upgraded our 10.2.01 database to 11.2.0.1 and compatible parameter has been set to11.2.0.1.0.
I also tried with include parameter but still showing ORA-31655.
Please help :(