当前位置: 首页 > news >正文

impdp恢复表后发现比原表多了100多行

因客户删除数据,恢复表时发现恢复表后发现比原表多了100多行,啥原因暂不清楚,继续学习

[oracle@hydb ~]$ more expdp_orcl_20240406_2100.log |grep '"USR_HY"."T_COPIES"'
. . exported "USR_HY"."T_COPIES"            1.446 MB   80836 rows

[oracle@hydb ~]$ impdp system/"********" directory=dir_dump dumpfile=orcl_20240506_2100_%U.dmp logfile=impdp_T_COPIES.log tables=USR_HY.T_COPIES remap_table=USR_HY.T_COPIES:T_COPIES20240506 transform=oid:n  

Import: Release 11.2.0.4.0 - Production on Wed May 8 11:24:39 2024

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": directory=dir_dump dumpfile=orcl_20240506_2100_%U.dmp logfile=impdp_T_SP_FREE_COPIES.log tables=USR_HY.T_SP_FREE_COPIES remap_table=USR_HY.T_SP_FREE_COPIES:T_SP_FREE_COPIES2024050621 transform=oid:n
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "USR_HY"."T_SP_FREE_COPIES20240506"  1.470 MB   81795 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-31684: Object type INDEX:"USR_HY"."USER_ID_ITEM_ID" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-31684: Object type CONSTRAINT:"USR_HY"."USER_ID_ITEM_ID" already exists
ORA-31684: Object type CONSTRAINT:"USR_HY"."SYS_C00441047" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"USR_HY"."USER_ID_ITEM_ID" already exists
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 4 error(s) at Wed May 8 11:24:54 2024 elapsed 0 00:00:14

http://www.lryc.cn/news/345791.html

相关文章:

  • Jupyter配置远程访问的密码
  • Windows下通过MySQL Installer安装MySQL服务
  • C语言 [力扣]详解环形链表和环形链表II
  • Threejs 学习笔记 | 灯光与阴影
  • SSH:安全远程访问的基石
  • 杰发科技AC7801——ADC之Bandgap和内部温度计算
  • 了解 macOS 中的系统完整性保护 (SIP):开启与关闭
  • 【Linux】简易进度条的实现
  • Docker + Django跨域解决方案
  • Maven 插件使用
  • 【HMGD】GD32/STM32 DMA接收不定长串口数据
  • 局域网手机端远程控制手机
  • 如何在OpenWrt软路由中增加一个新功能
  • 【linux】vmtouch文件缓存管理工具
  • 论文阅读:The Unreasonable Ineffectiveness of the Deeper Layers 层剪枝与模型嫁接的“双生花”
  • Python批量备份华为设备配置到FTP服务器
  • Java虚拟机(JVM)中确保资源及时释放的策略
  • 04-Fortran基础--Fortran数组和矩阵运算
  • el-select选项框内容过长
  • K8S面试题学习5
  • 字符以及字符串函数
  • 记录解决问题--redis ssl连接
  • 买卖股票的最佳时机
  • Linux部署安装
  • docker搭建mysql集群实现主从复制
  • Neo4j 之安装和 CQL 基本命令学习
  • 【全开源】JAVA台球助教台球教练多端系统源码支持微信小程序+微信公众号+H5+APP
  • 机器学习-如何为模型选择评估指标?
  • 【AutoGPT】踩坑帖(follow李鱼皮)
  • 机器学习-L1正则/L2正则