RE: Datapump error
- From: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Nov 2014 06:32:49 -0800
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 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
Other related posts:
