首页 > 其他分享 >exp导数据时报错ORA-01578 ORA-01110

exp导数据时报错ORA-01578 ORA-01110

时间:2023-01-14 23:00:31浏览次数:45  
标签:01110 01578 set 0.0 character emp exp oracle ORA

问题描述:exp导数据时报错ORA-01578 ORA-01110,如下所示:
数据库:oracle 19.12 多租户
1、异常重现
[oracle@dbserver ~]$ exp ora1/ora1@orclpdb file=emp.dmp tables=emp log=exp.log

Export: Release 19.0.0.0.0 - Production on Sat Jan 14 20:30:57 2023
Version 19.12.0.0.0

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


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table EMP
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 12, block # 659)
ORA-01110: data file 12: '+DATA/ORCLCDB/CBB47E352F7AAEA7E0537885A8C03007/DATAFILE/users.279.1082994667'
Export terminated successfully with warnings.
2、解决过程
SQL> conn sys/oracle_4U@orclpdb as sysdba
Connected.
SQL> alter system set events='10231 trace name context forever,level 10';

Session altered.

SQL> select count(*) from ora1.emp;

COUNT(*)
----------
140
[oracle@dbserver ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@dbserver ~]$ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8
[oracle@dbserver ~]$ exp ora1/ora1@orclpdb file=emp.dmp tables=emp log=exp.log

Export: Release 19.0.0.0.0 - Production on Sat Jan 14 20:41:11 2023
Version 19.12.0.0.0

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


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table EMP 140 rows exported
Export terminated successfully without warnings.

说明:如上成功导出emp表.

补充知识:
--关闭10231内部事件.
alter system set events='10231 trace name context off';

标签:01110,01578,set,0.0,character,emp,exp,oracle,ORA
From: https://blog.51cto.com/u_12991611/6007952

相关文章

  • oracle rowid字段解析
    文档课题:oraclerowid字段解析.1、相关概念rowid是一行数据的唯一标识,是数据的详细地址,通过rowid可快速定位某行数据的具体位置.其可分为物理rowid和逻辑rowid.普通堆表的r......
  • Oracle:字符串的拼接、截取、查找、替换
    一.拼接:1.使用“||”来拼接字符串:select'拼接'||'字符串'asStrfromdual;2.使用concat(param1,param2)函数实现:selectconcat('拼接','字符串')asStrf......
  • querySelectorAll和querySelector用法
    querySelectorAll和querySelector用法querySelector()方法返回文档中匹配指定CSS选择器的第一个元素,并且找到后就返回节点对象。querySelectorAll()找出所有匹配的节......
  • <Verilog学习>Verilog设计“111”检测器与“01110”检测器并测试所有情况
    使用Quartus+modelsim完成本次设计目录1."111"检测器分析代码实现Testbench结果2."01110"检测器分析代码实现Testbench结果1."111"检测器分析分析题目,得到其有限状......
  • ORACLE对象-高级(视图、序列、索引)
    ORACLE对象-高级一、视图(一)什么是视图视图和表的区别:视图是实体表的映射,视图和实体表区别就是于视图中没有真实的数据存在。视图中存储的是SQL语句什么时候使用视图:1.为......
  • ### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
    前言使用MyBatis进行SQL查询,报出SQL异常,原因为SQL语句最后结束加了分号(?)(?)org.springframework.jdbc.BadSqlGrammarException:###Errorqueryingdatabase.Cause:j......
  • Codeforces Round #843 (Div. 2) F. Laboratory on Pluto
    题目链接首先看问题一(算最小周长),并没有用题解的神奇结论,而是直接整除分块枚举\((n-1)/x\),取对应的最小x,在\(\sqrtn\)种可能内取最优的(能暴力算为什么要考虑结论呢)然而最......
  • CloudCanal实战-Oracle数据迁移同步到PostgreSQL
    简述本篇文章主要介绍如何使用CloudCanal构建一条Oracle到PostgreSQL的数据同步链路技术要点缩小的数据库权限要求CloudCanal对Oracle数据库的高权限要求,主要......
  • docker安装oracle
    我参考了 https://blog.csdn.net/u010148813/article/details/1261527341、我用的虚拟机(宿主机)是Ubunturoot@jin-virtual-machine:/etc/docker#lsb_release-aNoLSB......
  • CF244A Dividing Orange 题解
    Description有\(n\timesk\)个橘子,\(k\)个小朋友每人拿\(n\)个,但是每个人都指定了一个橘子\(a_i\),分配时必须要把\(a_i\)给第\(i\)个小朋友,求任一分配方案。So......