impdp ORA-39083: Object type INDEX_STATISTICS failed to create with error
来源:互联网 发布:apache 长度 编辑:程序博客网 时间:2024/06/04 17:40
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-01403: no data found
ORA-01403: no data found
Failing sql is:
导入的时候添加EXCLUDE=STATISTICS选项就ok了,导入结束之后使用dbms_stats.gather_schema_stats重新搜集统计信息。
导入命令示例:
impdp system/test dumpfile=expdat.dmp directory=tran exclude=transportable_export/materialized_view,transportable_export/table_statistics,transportable_export/grant/owner_grant/object_grant transport_datafiles='/oradata/oradata/testzj/ndmain1.dbf','/oradata/oradata/testzj/ndmain2.dbf'
在导入时有三个部分对象排除出去:
transportable_export/materialized_view:因为是测试环境,不需要同步数据,所以没有必要创建物化视图
transportable_export/grant/owner_grant/object_grant:因为新环境有很多用户不存在,保留授权会导致一大堆的报错信息,故排除
transportable_export/table_statistics:不导入表统计信息是为了避免bug:
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 12, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 4, column 127:
PL/SQL: SQL Statement ignored
refer:http://space6212.itpub.net/post/12157/411375
- impdp传输表空间错误小记 ORA-39083: Object type INDEX_STATISTICS failed to create with error:
- impdp ORA-39083: Object type INDEX_STATISTICS failed to create with error
- DataPump Import (IMPDP) Fails With Error ORA-39083 Object Type INDEX_STATISTICS (文档 ID 1454880.1)
- ORA-39083: Object type REF_CONSTRAINT failed to create with error:
- 数据泵导入时报错ORA-39083: Object type TABLE:"JDIC"."CLCP" failed to create with error:
- ORA-39082:Object type ALTER_PACKAGE_SPEC:""create with compilation warnings
- error:failed to create new object 0x80071392
- impdp failed with ORA-39002, ORA-31694 and ORA-31644
- Oracle Impdp Failed on RAC with ORA-31640, ORA-19505, ORA-27037, Linux-x86_64 Error: 2: No such file
- oracle数据泵导入错误:ORA-39082:Object type ALTER_PACKAGE_SPEC:""create with compilation warnings
- impdp with ora-39083 ora-01403
- ORA-31685: Object type DB_LINK:"NCAOODS"."LINK_SNAPSHOTM" failed due to insufficient privileges. Fai
- Install TDS with error "GLPCTL004E Failed to create database instance: 'ldapdb2'."
- Impdp Fails with ORA-39126 ORA-911 During Create Function (文档 ID 1254246.1)
- failed to create jvm error code -4
- Android project on Eclipse: Type Conversion to Dalvik format failed with error 1
- Failed to register Grid Infrastructure type ora.mdns.type
- Error : Failed to create the SD card. Error : Failed to create sdcard in the AVD folder.
- 新华社中移动共建搜索引擎
- 讲讲volatile的作用
- ORACLE创建表空间及数据库用户
- VS中web应用程序和Web网站区别
- 优缺点
- impdp ORA-39083: Object type INDEX_STATISTICS failed to create with error
- 三层结构
- JDK1.6在LINUX下的安装配置
- 文件描述符和文件指针的区别
- 重提URL Rewrite(4):不同级别URL Rewrite的一些细节与特点
- 游标循环结果集
- 委托 事件 密封类 静态类 抽象类 接口
- isapi_rewrite实现防盗链
- 用ISAPI_Rewrite实现反向代理(ReverseProxy)