Re: Datapump error
- From: "Mostafa Eletriby" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "m_etrib@xxxxxxxxx" for DMARC)
- To: "r.aialavajjala@xxxxxxxxx" <r.aialavajjala@xxxxxxxxx>, Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- Date: Mon, 3 Nov 2014 23:36:51 -0800
Thank you Rajesh,
I followed the note id , & trying to find the shared object which is index
between two tablespaces.
I listed all objects at tablespace DPIPE_OVERFLOW_SEG but all objects type:
TABLE - TABLE PARTITION
There is no object type: INDEX
I don't know any other way to find this index in order to move it to another
tablespace.
Please advice.
Regards,
On Monday, November 3, 2014 4:42 PM, Rajesh Aialavajjala
<r.aialavajjala@xxxxxxxxx> wrote:
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:
