Exp-00056 Oracle Error 904 Encountered Ora-00904
Contents |
production database and found this error:Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle exp-00008 oracle error 904 encountered ora-00904 invalid identifier Data Mining optionsJServer Release 9.2.0.8.0 - ProductionExport done in US7ASCII character
Oracle Error 904 Ora-00904 Invalid Identifier
set and AL16UTF16 NCHAR character setserver uses WE8ISO8859P1 character set (possible charset conversion)Note: table data
Ora-00904: Invalid Identifier
(rows) will not be exportedAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user RCUSER. exporting PUBLIC
Exp 00008 Oracle Error 1003 Encountered
type synonyms. exporting private type synonyms. exporting object type definitions for user RCUSERAbout to export RCUSER's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export RCUSER's tables via Conventional Path .... . exporting table BVDEFAGREEMENTEXP-00056: ORACLE error 904 encounteredORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifierBase on Oracle Documents to error code 904 oracle fix this problem...Doc ID: 358508.1.Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1This problem can occur on any platform.Symptoms Export fails with: EXP-00056: ORACLE error 904 encounteredORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifierChanges A patchset was recently installed against the database. Cause After the patchset installation, the data dictionary components have not been upgraded to the patchset release (e.g. 10.1.0.4)A patchset (e.g. 10.1.0.4) was applied to an existing ORACLE_HOME install but one or more of the patchset steps were not performed per the patchset readme to bring the database components up to the same version as the patched software as shown in DBA_REGISTRY.If the database components versions do not match the software and the running instance, then the exp utility fails as it finds an earlier version of the exp packages in the database.Solution Follow the Post-Installation Tasks section of the Oracle Database Server Patch Set Notes to run the catpatch.sql script with
on Wed Jul 25 10:47:29 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.5.0 exp 00008 oracle error 3113 encountered - ProductionExport done in US7ASCII character set and AL16UTF16 NCHAR character setserver uses exp-00008 oracle error 1555 encountered UTF8 character set (possible charset conversion) About to export specified tables via Direct Path ...Current user changed to DBAPL. error 904 android . exporting table RPT_LOCAL__01 1012208 rows exportedEXP-00056: ORACLE error 904 encounteredORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifierExport terminated successfully with warnings.[Root Cause]It caused by different DB version in the server , as below two http://ronniedba.blogspot.com/2009/01/exp-00056-oracle-error-904-encountered.html version is installed: DB1 V9.2.0.8 , while DB2 is 9.2.0.5 In operator id 's env , the ORACLE_HOME is point to 9.2.0.8, caused using higher version exp to exp data from lower version db. [solution]in the script , explicitly specify the path of exp , i.e: /software/oradb1/product/9.2.0/bin/exp $RPT_CONNECT@$RPT_DB file=$expfile log=$LOGFILE direct=y recordlength=65535 buffer=10240000 compress=N tables=${tab_name} statistics=none Today 21-Jan-2009, hit another similar case. http://midba.blogspot.com/2007/07/ora-00904-sysdbmsexportextensionfuncind.html get new findings from metalink Doc ID: 358508.1.Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1This problem can occur on any platform. Symptoms Export fails with: EXP-00056: ORACLE error 904 encounteredORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifierChanges A patchset was recently installed against the database. Cause After the patchset installation, the data dictionary components have not been upgraded to the patchset release (e.g. 10.1.0.4)A patchset (e.g. 10.1.0.4) was applied to an existing ORACLE_HOME install but one or more of the patchset steps were not performed per the patchset readme to bring the database components up to the same version as the patched software as shown in DBA_REGISTRY.If the database components versions do not match the software and the running instance, then the exp utility fails as it finds an earlier version of the exp packages in the database.Solution Follow the Post-Installation Tasks section of the Oracle Database Server Patch Set Notes to run the catpatch.sql script with the database started in migrate mode and then retry the export.Connect to the database as SYSDBA and run:SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
SQL>
Mon, 07 August 2006 10:25 rafi_aamiri Messages: 34Registered: September 2005 Member Hi, While trying to http://www.orafaq.com/forum/t/67440/ export with oracle 9.2.0.7.0 in XP I am able to export the tables with the below error EXP-00056: ORACLE error 904 encountered ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid http://marc.info/?l=hpux-admin&m=115495815318527 identifier . . exporting table emp_jan 4 rows exported Please help me in this regard. Report message to a moderator Re: ORA-00904 oracle error -- Export Problem [message #186349 is a reply to message #186345] Mon, 07 August 2006 10:42 ebrian Messages: 2794Registered: April 2006 Senior Member Did you recently patch the database? If so, you'll want to ensure that you ran the catpatch.sql as SYS. Report message to a moderator 00008 oracle error Previous Topic: RMAN Writing to Tape Next Topic: rename database Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Sat Oct 15 05:02:41 CDT 2016 Total time taken to generate the page: 0.04770 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.
20060807132742.63502.qmail () web60324 ! mail ! yahoo ! com [Download message RAW] Hello, I have trouble exporting the Recovery Catalog: Any help to troubleshoot or fix this problem wud be very useful... Thanks in advance Regards Deepak Few lines form the log are attached: archive log filename=/d/db/app/oracle/admin/djc/arc/arch1_778.dbf recid=771 stamp=597500507 Finished backup at 08/03/2006 [12:37:14] released channel: dev_1 released channel: dev_2 released channel: dev_3 released channel: dev_0 RMAN> **end-of-file** RMAN> Recovery Manager complete. [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:19 Oracle RMAN successfully finished. [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:19 Issuing DP Managed Control File Backup ... [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:21 Starting OB2BAR Backup: coldb.west1jetlag.dcn.pri.o2.com:djc DP Managed Control File Backup "Oracle8" [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:24 Backup Profile: Run Time ........... 0:00:03 Backup Speed ....... 2301.33 (KB/s) [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:24 Completed OB2BAR Backup: coldb.west1jetlag.dcn.pri.o2.com:djc DP Managed Control File Backup "Oracle8" [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:24 Starting backup of the Oracle Recovery Catalog Database ... [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:25 Getting NLS_LANG and setting it into the environment .... AMERICAN_FRANCE.AL32UTF8 Default exp binary /opt/oracle/product/9i/bin/exp is used for catalog export. [Major] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:57 Export of the Recovery Catalog Database failed. Export: Release 9.2.0.7.0 - Production on Thu Aug 3 12:37:25 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production JServer Release 9.2.0.4.0 - Production Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set server uses US7ASCII character set (pdjcible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user RMANF . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user RMANF About to export RMANF's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export RMANF's tables via Conventional Path ... . . exporting table AL 585 rows exported