RE: Datapump error

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Mon, 3 Nov 2014 06:32:49 -0800
Message-ID: <BLU179-W306A7CD52A8D6608754F7EEB990_at_phx.gbl>

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_at_freelists.org
Subject: Datapump error
To: oracle-l_at_freelists.org

Dear All,Kindly help me to solve this error at data pump DB:11.2.0.2 O.s: Windows 2008 Enterprise R2 64 BitPlease advice.Regards,C:\Users\orasupport>expdp directory=data_pump_dir dumpfile=TS_DPIPE_OVERFLOW_SEG.dmp logfile=TS_DPIPE_OVERFLOW_SEG.log tablespaces=DPIPE_OVERFLOW_SEGExport: Release 11.2.0.2.0 - Production on Mon Nov 3 15:12:21 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Username: / as sysdbaConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bitProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsStarting "SYS"."SYS_EXPORT_TABLESPACE_01": /******** AS SYSDBA directory=data_pump_dir dumpfile=TS_DPIPE_OVERFLOW_SEG.dmp logfile=TS_DPIPE_OVERFLOW_SEG.log tablespaces=DPIPE_OVERFLOW_SEGEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 0 KBORA-31655: no data or metadata objects selected for jobJob "SYS"."SYS_EXPORT_TABLESPACE_01" completed with 1 error(s) at 15:12:32

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 03 2014 - 15:32:49 CET