Exp-00008 Oracle Error 8103
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog exp 00008 oracle error 904 encountered
EXP-00008:Exp 00008 Oracle Error 6552 Encountered
ORACLE error 904 encountered tips Oracle Database Tips by Burleson Consulting Question: I am trying to export a exp-00008 oracle error 904 encountered ora-00904 invalid identifier table and I have this "EXP-00008: ORACLE error 904 encountered" error message: Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production About to export specified tables via Conventional Path ... EXP-00008: ORACLE
Oracle Error 904 Ora-00904 Invalid Identifier
error 904 encountered ORA-00904: invalid column name Answer: The EXP-0008 with the 904 "invalid column name" will always write a trace file, and you can check the trace file in your UDUMP directory to see the specific cause. The "EXP-00008: ORACLE error 904 encountered" error can happen for several reasons: The most common cause of the EXP-0008 with the 904 code is a exp 00008 oracle error 1003 encountered mismatch between the Oracle client and the database. Verify that the version of your exp utility matches the database version. This 904 error can happen if you forget to run catproc.sql. Also see MOSC Note:1017276.102 "Oracle8i Export Fails on Synonym Export with EXP-00008 and ORA-00904". This notes that a synonym named "DBMS_JAVA" or "DBMS_JAVA_TEST" may exist without a corresponding package. Get the Complete Oracle Utility Information The landmark book "Advanced Oracle Utilities The Definitive Reference" contains over 600 pages of filled with valuable information on Oracle's secret utilities. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Ora
that we could use it locally using the exp tool. I had to connect to exp like this: exp user/password@remote_address And then filled in the other parameters interactively. Unfortunately when I tried to actually export the specified tables I got the following error message:
Exp-00008 Oracle Error 1555 Encountered
EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully I eventually came
Ora-00904: Invalid Identifier
across Oyvind Isene's blog post which pointed out that you'd get this problem if you tried to export a 10g database using an 11g exp 00008 oracle error 3113 encountered client which is exactly what I was trying to do! He explains it like so: The export command runs a query against a table called EXU9RLS in the SYS schema. On 11g this table was expanded with the column http://www.dba-oracle.com/t_exp_00008_904_error.htm POLTYP and the export command (exp) expects to find this column. I needed to download the 10g client so that I could use that version of exp instead. I haven't quite got it working yet but at least it's a different error to deal with! Be Sociable, Share! Tweet Written by Mark Needham January 13th, 2012 at 9:46 pm Posted in Software Development Tagged with oracle, Software Development « Learning Android: Roboguice - Injecting context into PreferenceManager Wireshark: Following HTTP http://www.markhneedham.com/blog/2012/01/13/oracle-exp-exp-00008-oracle-error-904-encounteredora-00904-poltyp-invalid-identifier/ requests/responses » Ali_mostafa24 Hi, I tried to exp and hit same error but after doing some analysis I came across below finding. Error: EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully Scenario 1: DB Instance 32 bit EXP possible via SQL :聽DB client 32 bit only Scenario 2: DB Instance 64 bit EXP possible via SQL:聽DB client 32 bit & 64 bit Regards,Alee Twitter Email Subscribe by email Search for: Archives Archives Select Month October 2016 (2) September 2016 (1) August 2016 (4) July 2016 (8) June 2016 (6) May 2016 (2) April 2016 (2) February 2016 (1) January 2016 (2) December 2015 (6) November 2015 (5) October 2015 (6) September 2015 (5) August 2015 (11) July 2015 (17) June 2015 (21) May 2015 (17) April 2015 (16) March 2015 (19) February 2015 (12) January 2015 (9) December 2014 (10) November 2014 (13) October 2014 (11) September 2014 (10) August 2014 (10) July 2014 (10) June 2014 (10) May 2014 (10) April 2014 (10) March 2014 (4) February 2014 (10) January 2014 (10) December 2013 (4) November 2013 (16) October 2013 (14) September 2013 (19) August 2013 (16) July 2013 (20) June 2013 (20) May 2013 (15) April 2013 (19) March 2013 (20) February 2013 (20) January 2013 (20) December 2012 (23) November 2012 (16) October 2012 (17) September 2012 (18) August 2012 (8) July 2012 (17) June 2012 (13) Ma
比特币 小额贷款 贷款 crm ORACLE 项目管理系统 thread android python java 本版文章帖子用户 ITPUB论坛-中国最专业的IT技术社区»论坛 › ≡ http://www.itpub.net/thread-648923-1-1.html 大数据与数据库 ≡ › Oracle数据库管理 › EXP-00008: ORACLE error 8103 encountered 细数 “分布式计算系统”令你不爽的那些瞬间! oracle技术交流群,欢迎大家加入! 大数据时代,每家公司都要有大数据部门? 返回列表 查看: 2463|回复: 2 收藏 http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client | EXP-00008: ORACLE error 8103 encountered [复制链接] funnyok funnyok 当前离线 积分101 IP卡 狗仔卡 论坛徽章:28 电梯直达 1# 发表于 2006-10-16 oracle error 09:42 | 只看该作者 |倒序浏览 |阅读模式 exp的时候有时候发生下面的错误。 为什么? EXP-00008: ORACLE error 8103 encountered ORA-08103: object no longer exists 虽然exp的时候有transaction但是没有create和drop Oracle 9.2.0.4 Linux RHEL3.0 R5 多谢 ORACLE, error, object, exists, transaction 收藏0 相关帖子 本版精华 《Oracle DBA从小白到入职实战应用》最最最实用Oracle实践技能课程,新人入行必修 《深入浅出Oracle》DBA老鸟授课从原理到实战,引领新手们从入门到精通 Oracle发布紧急Java更新,修复关键漏洞 恭喜superking915上任ERP二次开发版版主 给2016 00008 oracle error DTCC的新春寄语:说出你与数据大会的那些年那些事。。。。 【大话IT】2016,我们能和大数据发生点啥? 推荐yingyifeng306为oracle高可用板块版主,请大家发表意见~ 推荐yingyifeng306为oracle高可用板块版主,请大家发表意见~ 《IT名人堂》采访Oracle开发大师:苏旭晖先生(ID:newkid) oracle技术交流群,欢迎大家加入! Oracle 运维最佳实践 无私奉献 企业级DBA--学习手册(中文版)体系结构,性能优化 《Oracle Golden Gate图文并茂快速掌握》(附下载) 图文并茂Mutex性能问题解析(一) 深入oracle log buffer发展史 技术人生系列 · 我和数据中心的故事(第一期)——小机上运行Oracle数据库需要注意的 Oracle SQL命令通解三步曲 [三思笔记]-手把手教你用vmware安装oracle10g RAC 搞懂oracle字符集 Oracle SQL*Loader 使用指南 使用道具 举报 回复 提升卡 置顶卡 变色卡 显身卡 funnyok funnyok 当前离线 积分101 IP卡 狗仔卡 论坛徽章:28 2# 楼主| 发表于 2006-10-16 15:23 | 只看该作者 没有人看吗? 顶以下 使用道具 举报 回复 显身卡 i_am_a_dba i_am_a_dba 当前离线 积分101 IP卡 狗仔卡 论坛徽章:0 3# 发表于 2006-10-17 11:43 | 只看该作者 Sounds like you are hitting a bug... Are you using direct path export? Have you tried conventional export for the table(s) effected? 使用道具 举报 回复 显身卡 返回列表 高级模式 B Color Image Link Quote Code Smilies 您需要登录后才可以回帖 登录 | 注册 本版积分规则 发表回复 回帖后跳转到最后一页 想免费?10张SACC2016门票等你来拿~ 或许,你错过
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Export from Oracle 10g database with 11g client up vote 10 down vote favorite Database Version : 10g Enterprise Edition Release 10.2.0.4.0 Client Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When I try to export (exp) a table from database: exp usr/pass@remote_db file=f.dmp tables=table I get the following error: EXP-00008: ORACLE error 904 encountered ORA-00904: "POLTYP": invalid identifier EXP-00000: Export terminated unsuccessfully I searched about it on the net and I understand that the problem is version incompatibility. What do you advice me to do about it? NOTE: I also tried to export with data pump but it gives: UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0 oracle oracle10g oracle11gr2 datapump share|improve this question asked Dec 21 '11 at 16:13 bonsvr 1,25641427 I think it would be appropriate to ask to dba.stackexchange.com –Luc M Dec 21 '11 at 16:23 add a comment| 2 Answers 2 active oldest votes up vote 11 down vote accepted Generally speaking, Oracle export is not backward compatible with prior releases. You'll need to use the 10g export on the 10g database. Get the 10g client and install it with the database utilities option to get the exp/imp tools. On the flip side, Oracle imp is generally backward compatible with prior releases of exp. share|improve this answer answered Dec 21 '11 at 16:44 DCookie 28.8k84765 add a comment| up vote 0 down vote I use VERSION=10.2 from a 11g client share|improve this answer answered May 22 '14 at 17:52 Ankit 845816 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Na