Re: Datapump error
Date: Mon, 3 Nov 2014 23:36:51 -0800
Message-ID: <1415086611.82131.YahooMailNeo_at_web162402.mail.bf1.yahoo.com>
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_at_gmail.com> 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_at_hotmail.com> 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_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 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
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 04 2014 - 08:36:51 CET