Home » RDBMS Server » Server Utilities » EXP-00008: ORACLE error 904 encountered (10g, 10.2.0.4.0, windows 64bit)
EXP-00008: ORACLE error 904 encountered [message #578909] Wed, 06 March 2013 04:54 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

While running export script, i am getting error. Don't know, what could be the problem. Below are the part of log file.



Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)




EXP-00008: ORACLE error 904 encountered
ORA-00904: "IFREEPOOL": invalid identifier
. . exporting table                   DEF$_AQERROR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table                  DEF$_CALLDEST          0 rows exported
. . exporting table               DEF$_DEFAULTDEST          0 rows exported
. . exporting table               DEF$_DESTINATION          0 rows exported
. . exporting table                     DEF$_ERROR          0 rows exported
. . exporting table                       DEF$_LOB
EXP-00008: ORACLE error 904 encountered
ORA-00904: "IFREEPOOL": invalid identifier
. . exporting table                    DEF$_ORIGIN          0 rows exported
. . exporting table                DEF$_PROPAGATOR          0 rows exported
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exported
. . exporting table                  DEF$_TEMP$LOB
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table       LOGSTDBY$APPLY_MILESTONE          0 rows exported
. . exporting table        LOGSTDBY$APPLY_PROGRESS
. . exporting partition                             P0          0 rows exported
. . exporting table                LOGSTDBY$EVENTS
EXP-00008: ORACLE error 904 encountered
ORA-00904: "IFREEPOOL": invalid identifier
. . exporting table               LOGSTDBY$HISTORY          0 rows exported



Kindly assist me to get the solution.

Regards,
Ishika
Re: EXP-00008: ORACLE error 904 encountered [message #578929 is a reply to message #578909] Wed, 06 March 2013 08:18 Go to previous messageGo to next message
joy_division
Messages: 4528
Registered: February 2005
Location: East Coast USA
Senior Member
What is the version of the database and what is the version of the export utility?
Re: EXP-00008: ORACLE error 904 encountered [message #578939 is a reply to message #578929] Wed, 06 March 2013 08:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Amazing! the one post part of the log but NOT the beginning of it where the version is mentioned.
Why? Why truncate this part of the log?

Regards
Michel
Re: EXP-00008: ORACLE error 904 encountered [message #578943 is a reply to message #578939] Wed, 06 March 2013 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>ORA-00904: "IFREEPOOL": invalid identifier
what OBJECT_TYPE is IFREEPOOL & which schema owns it?

post the COMPLETE command line of the whole export command without any obfuscation
Re: EXP-00008: ORACLE error 904 encountered [message #579015 is a reply to message #578943] Thu, 07 March 2013 01:22 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Please find the log...

export log

Regards,
Ishika


[Edit MC: put log in spoiler]

[Updated on: Thu, 07 March 2013 01:33] by Moderator

Report message to a moderator

Re: EXP-00008: ORACLE error 904 encountered [message #579023 is a reply to message #579015] Thu, 07 March 2013 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first lines are still missing.
Why do you hide them?

Regards
Michel
Re: EXP-00008: ORACLE error 904 encountered [message #579033 is a reply to message #579023] Thu, 07 March 2013 02:02 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

This is the export log file which generates during the process. Why do hide anything, if i want proper solution?

Regards,
Ishika
Re: EXP-00008: ORACLE error 904 encountered [message #579036 is a reply to message #579033] Thu, 07 March 2013 02:11 Go to previous message
Littlefoot
Messages: 19687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Look what is missing - export utility version (painted in red):

M:\>exp

Export: Release 11.2.0.2.0 - Production on Čet Ožu 7 09:10:11 2013

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


Username: scott@ora10
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >
Previous Topic: Import million data from excel to Oracle 11g
Next Topic: How to load unstructured data
Goto Forum:
  


Current Time: Tue Oct 21 17:50:47 CDT 2014

Total time taken to generate the page: 0.09491 seconds