Error Using 11g Export Client 10g Database
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings exp-00008 oracle error 904 encountered ora-00904 invalid identifier and policies of this site About Us Learn more about Stack Overflow
Oracle Error 904 Ora-00904 Invalid Identifier
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation
Ora 00904 Invalid Identifier During Export
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
Ora-00904: Invalid Identifier
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 oracle bug 7568350 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 vo
log in tour help Tour Start 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 exp-00008 oracle error 1555 encountered Stack Overflow the company Business Learn more about hiring developers or posting ads with exp-00008 oracle error 3113 encountered us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for ora-00904: "poltyp" database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody http://stackoverflow.com/questions/8592873/export-from-oracle-10g-database-with-11g-client can answer The best answers are voted up and rise to the top export data from oracle 10g up vote 2 down vote favorite I installed Oracle 11g on my computer. When I export data from Oracle 10g, I get the following error code. I have translated the error in parenthesis. EXP-00008: 遇到 ORACLE 错误 904 (encouter oracle error 904) ORA-00904: "POLTYP": 标识符无效 (POLTYP: is not valid ) EXP-00000: 导出终止失败 (export fail) http://dba.stackexchange.com/questions/13715/export-data-from-oracle-10g Does someone know why? I believe it is ok to export from Oracle 10g using Oracle 11g client. oracle export share|improve this question edited Feb 23 '12 at 7:23 omggs 1388 asked Feb 23 '12 at 2:33 snow8261 16611 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Unfortunately not, you cannot export from a 10g database with the 11g client. You can, though, use a dump file from a 10g database (exported with the 10g client) to import into an 11g database (with the 11g client). Alternatively you can use the newer datapump functionality, and if you create a database link from 11g to 10g you can even transfer the data directly between them without needing to create an intermediate dump file at all. share|improve this answer answered Feb 23 '12 at 7:36 Alex Poole 2,0601820 i get it. thanks. i thought it can work. –snow8261 Feb 23 '12 at 8:53 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 Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy polic
repeately this question How do i export from higher version and import into lower version.I just show here How https://mohamedazar.com/2011/01/23/how-to-export-from-oracle-11-2-and-import-into-10-2-version/ do we do. First : Using Datapump from Oralce 11.2 and import into 10.2 version Source DB 11.2 Version : Step 1: Create Directory SQL> create or replace http://www.dba-oracle.com/t_export_import_different_releases_of_oracle.htm directory test_dir as 'D:\backupnew\dump'; Directory created. SQL> grant read,write on directory test_dir to scott; Grant succeeded. SQL> conn scott/tiger@azardb Connected. SQL> create table testversion(version varchar2(20)); Table created. oracle error SQL> insert into testversion values('oralce11gr2'); 1 row created. SQL> commit; Commit complete. Step 2: Export Table using Datapump C:\Users\mazar>expdp scott/tiger@azardb directory=test_dir dumpfile=testver.dmp tables=testversion Export: Release 11.2.0.1.0 - Production on Sun Jan 23 15:54:13 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production exp-00008 oracle error With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/********@azardb directory=test_dir dumpfile=testver.dmp tables=testversion Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 64 KB Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "SCOTT"."TESTVERSION" 5.031 KB 1 rows Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is: D:\BACKUPNEW\DUMP\TESTVER.DMP Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 15:54:40 Now Go to Target DB 10.2 Version Step 3: Create Directory for Scott User. SQL> create or replace directory test_dir as 'd:\newdump'; Directory created. SQL> grant read,write on directory test_dir to scott; Grant succeeded. Step 3: I just Copied this TESTVER.DMP file into target DB 10.2 Directory and import it D:\oracle\product\10.2.0\db_2\BIN>impdp scott/tiger@ace directory=test_dir dumpf ile=testversion.dmp tables=testversion Import: Release 10.2.0.1.0 - 64bit Production on Sunday, 23 January, 2011 16:04: 31 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options ORA-39001: invalid ar
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
How to export between releases of Oracle Oracle Database Tips by Burleson Consulting April 7, 2015 Question: I am trying to take a 10g export file and import it into Oracle 11g.How do I use the Oracle11g Data Pump impdp import with a dmp file that was created from Oracle 10g?Answer: While there is never a guarantee that an later release expdp dmp file will import into an earlier release of Oracle (this is called "forward compatibility", impossible because Oracle can never know about future enhancements) and are indeed cases where you can export from a later release of Oracle and import into an earlier release. For full secrets and tips for exporting and importing between releases, see the book Advanced Oracle Utilities: The Definitive Reference. In some cases an older export is indeed backward compatible to a newer release: - Export with exp and import using the impdp Data Pump Utility (exp from 8i and 9i to 10g and 11g). - Using the version parameter in Data Pump. Export/Import between different releases of Oracle Oracle Data Pump was first released in Oracle 10g (expdp and impdp). Priot to Data Pump, Oracle used the "exp" and "imp" utilities. In your case, both the export (expdp) and import (impdp) are with Data Pump and you can use the version [parameter to export from a later release of Oracle an import that dump file into an earlier release of Oracle. You can import your 11g expdp dump file into Oracle 10g if you make sure you use "VERSION=10.2" parameter during export. Here is a working example of using the expdp version parameter to make a dump file acceptable to an earlier release