Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-31655: no data or metadata objects selected for job while exporting tablespace

mazhar parkarNov 22 2016 — edited Nov 27 2016

I am trying to export tablespace of PDB and i am getting the below error

"ORA-31655: no data or metadata objects selected for job"

Please find the CMD details below

SQL> select tablespace_name,SEGMENT_SPACE_MANAGEMENT,EXTENT_MANAGEMENT from cdb_tablespaces;

TABLESPACE_NAME                SEGMEN EXTENT_MAN

------------------------------ ------ ----------

SYSTEM                         MANUAL LOCAL

SYSAUX                         AUTO   LOCAL

UNDOTBS1                       MANUAL LOCAL

TEMP                           MANUAL LOCAL

USERS                          AUTO   LOCAL

TEST                           MANUAL LOCAL

SYSTEM                         MANUAL LOCAL

SYSAUX                         AUTO   LOCAL

TEMP                           MANUAL LOCAL

USERS                          AUTO   LOCAL

EXAMPLE                        AUTO   LOCAL

TABLESPACE_NAME                SEGMEN EXTENT_MAN

------------------------------ ------ ----------

PDBUSERS                       AUTO   LOCAL

C:\Users\User>expdp tablespaces=PDBUSERS directory=datapumpdir dumpfile='PDBUSERSTBLSPS1.dmp' logfile='PDBUSERSEXPORT.LOG'

Export: Release 12.1.0.2.0 - Production on Tue Nov 22 20:33:17 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: c##mazhar

Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting "C##MAZHAR"."SYS_EXPORT_TABLESPACE_01":  c##mazhar/******** tablespaces=PDBUSERS directory=datapumpdir dumpfile='PDBUSERSTBLSPS1.dmp' logfile='PDBUSERSEXPORT.LOG'

Estimate in progress using BLOCKS method...

Total estimation using BLOCKS method: 0 KB

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

ORA-31655: no data or metadata objects selected for job

Job "C##MAZHAR"."SYS_EXPORT_TABLESPACE_01" completed with 1 error(s) at Tue Nov 22 20:33:27 2016 elapsed 0 00:00:01

C:\Users\User>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2016
Added on Nov 22 2016
3 comments
3,336 views