parknkjun

Focus on Oralce Focus on Mysql 版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

  • 博客访问: 408768
  • 博文数量: 115
  • 用 户 组: 普通用户
  • 注册时间: 2008-02-11 15:59
  • 认证徽章:
个人简介

姓名:江政恒 网络ID:parknkjun Oracle 10g OCM, Oracle 11g,12c OCP, OCMU成员, Oracle Young Expert 邮箱:parknkjun@163.com 电话:15502113137 QQ群:136904065

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2017年(2)

2016年(24)

2015年(61)

2014年(27)

2013年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

分类: Oracle

使用expdp导出表空间时遇到ORA-31655: no data or metadata objects selected for job错误
[oracle@jzh5 ~]$ expdp jzh/jzh tablespaces=test directory=dir dumpfile=test.dmp
Export: Release 11.2.0.3.0 - Production on Wed Dec 21 03:10:46 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "JZH"."SYS_EXPORT_TABLESPACE_01":  jzh/******** tablespaces=test directory=dir dumpfile=test.dmp 
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-31655: no data or metadata objects selected for job
Job "JZH"."SYS_EXPORT_TABLESPACE_01" completed with 1 error(s) at 03:10:47

检查表空间发现test表空间是小写:
SYS@jzh>select tablespace_name from dba_data_files;
TABLESPACE_NAME
------------------------------
USERS
UNDOTBS1
SYSAUX
SYSTEM
EXAMPLE
test
重命名表空间导出就可以了
SYS@jzh>alter tablespace "test" rename to test;
Tablespace altered.
SYS@jzh>select tablespace_name from dba_data_files;
TABLESPACE_NAME
------------------------------
USERS
UNDOTBS1
SYSAUX
SYSTEM
EXAMPLE
TEST

[oracle@jzh5 ~]$ expdp jzh/jzh tablespaces=test directory=dir dumpfile=test.dmp
Export: Release 11.2.0.3.0 - Production on Wed Dec 21 03:20:03 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "JZH"."SYS_EXPORT_TABLESPACE_01":  jzh/******** tablespaces=test directory=dir dumpfile=test.dmp 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "JZH"."T1"                                  7.236 MB   74798 rows
Master table "JZH"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for JZH.SYS_EXPORT_TABLESPACE_01 is:
  /home/oracle/test.dmp
Job "JZH"."SYS_EXPORT_TABLESPACE_01" successfully completed at 03:20:10





阅读(13) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册