Re: Datapump error
- From: Rajesh Aialavajjala <r.aialavajjala@xxxxxxxxx>
- To: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- Date: Mon, 3 Nov 2014 09:38:53 -0500
Mostafa,
You might want to review "DataPump Export Tablespace With Data Causes
ORA-31655 No Data Or Metadata Objects Selected For Job (Doc ID 751071.1)" -
this discusses the issue that Iggy pointed out.
Thanks,
--Rajesh
On Mon, Nov 3, 2014 at 9:32 AM, Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
wrote:
> The error is "no data or metadata objects selected for job" which, in
> your case, means that data pump did not find any objects to process in your
> command line. Perhaps you made a spelling mistake in the tablespace name or
> perhaps it really does not contain any objects that data pump can process.
>
> Iggy
>
>
> ------------------------------
> Date: Mon, 3 Nov 2014 05:22:42 -0800
> From: dmarc-noreply@xxxxxxxxxxxxx
> Subject: Datapump error
> To: oracle-l@xxxxxxxxxxxxx
>
>
> Dear All,
> Kindly help me to solve this error at data pump DB:11.2.0.2 O.s: Windows
> 2008 Enterprise R2 64 Bit
> Please advice.
> Regards,
>
> C:\Users\orasupport>expdp directory=data_pump_dir
> dumpfile=TS_DPIPE_OVERFLOW_SE
> G.dmp logfile=TS_DPIPE_OVERFLOW_SEG.log tablespaces=DPIPE_OVERFLOW_SEG
>
>
> Export: Release 11.2.0.2.0 - Production on Mon Nov 3 15:12:21 2014
>
> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights
> reserved.
>
> Username: / as sysdba
>
> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 -
> 64bit
> Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
> Starting "SYS"."SYS_EXPORT_TABLESPACE_01": /******** AS SYSDBA
> directory=data_p
> ump_dir dumpfile=TS_DPIPE_OVERFLOW_SEG.dmp
> logfile=TS_DPIPE_OVERFLOW_SEG.log tab
> lespaces=DPIPE_OVERFLOW_SEG
> 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 15:12:32
>
>
>
Other related posts:
