Home » RDBMS Server » Server Utilities » Export Error
Export Error [message #283878] Wed, 28 November 2007 06:01 Go to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

Hi i am having a problem when trying to export my DB,i could run an import fine,i have ran the catalog.sql,catproc.sql,catexp.sql and utlrp.sql again.Is it because the client and DB are different?How can i solve this problem


exp usr/pass file=exp_full.dmp log=exp_full.log full=y consistent=y

Export: Release 8.1.7.0.0 - Production on Wed Nov 28 13:40:04 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
Re: Export Error [message #283879 is a reply to message #283878] Wed, 28 November 2007 06:04 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You should use Oracle Server export utiltiy to export your database.
Re: Export Error [message #283880 is a reply to message #283878] Wed, 28 November 2007 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use export utility of release less or equal than server (the best is equal), never greater.
Your exp is 8.1.7 and your database is 8.1.6.

Regards
Michel
Re: Export Error [message #283883 is a reply to message #283878] Wed, 28 November 2007 06:12 Go to previous messageGo to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

Sorry for not understanding,where can i find Oracle server export,is in on the server or i should get a third party utility? In Order to use export utility less or equal how do i go about doing that on the same server?
Re: Export Error [message #283888 is a reply to message #283883] Wed, 28 November 2007 06:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

or i should get a third party utility?
NO, no need to buy anything.
export utiltiy is exist on Oracle Server and Oracle Client.

Here is your client exp binary is higher than your Server that is why you getting error, so you should use your server export binary to export your database.

Check Micheal reply in previous post.
Re: Export Error [message #283891 is a reply to message #283878] Wed, 28 November 2007 06:27 Go to previous messageGo to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

"so you should use your server export binary to export your database",how do i do/achieve this? because i am just used to using imp/exp [options] ...
Re: Export Error [message #283893 is a reply to message #283891] Wed, 28 November 2007 06:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Just go to Oracle Server machine.
and export whatever you want through EXP command.
Re: Export Error [message #283894 is a reply to message #283878] Wed, 28 November 2007 06:35 Go to previous messageGo to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

ok,but is it not what's the actual problem for me,because i am trying to do the export on the server and thus get the error that i posted.
Re: Export Error [message #283897 is a reply to message #283894] Wed, 28 November 2007 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The actual problem is that you export program version is 8.1.7 that is greater than your database one which is 8.1.6.
Full stop.

Regards
Michel
Re: Export Error [message #283905 is a reply to message #283878] Wed, 28 November 2007 06:56 Go to previous messageGo to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

And how can i solve this problem?
Re: Export Error [message #283938 is a reply to message #283905] Wed, 28 November 2007 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use the correct exp.
If you didn't scramble your installation it is in the server Oracle home.

Regards
Michel

[Updated on: Wed, 28 November 2007 07:36]

Report message to a moderator

Re: Export Error [message #283957 is a reply to message #283878] Wed, 28 November 2007 08:01 Go to previous messageGo to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member

Thanks,when i run the export from d:\oracle\Ora81\Bin the export goes through fine.
Re: Export Error [message #283963 is a reply to message #283957] Wed, 28 November 2007 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Re: Export Error [message #475700 is a reply to message #283963] Thu, 16 September 2010 14:29 Go to previous messageGo to next message
muktha_22
Messages: 394
Registered: December 2009
Senior Member
Hi Mickel,

Need a clarification on your point above.
You said.
Causes of the error, because the export version is 8.1.7 and the Database version is 8.1.6.

Q1:
How this conflict can happen. Because I'm running export utility on the same database, which needs to be exported.

Q2:
Can we use one Database's export utility for exporting other database's schema?

Q3:
Which export and import version will be taken by default, if I have 2 DB (9 & 10g)

Thanks in advance
Re: Export Error [message #475703 is a reply to message #475700] Thu, 16 September 2010 15:01 Go to previous message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Q1) Already answered: "Use export utility of release less or equal than server (the best is equal), never greater."
Q2) Yes, if it follows the previous rule
Q3) See above: export with the lowest database version

Regards
Michel
Previous Topic: Import Error
Next Topic: Oracle migration from 8 to 11gR2
Goto Forum:
  


Current Time: Tue Sep 16 21:31:10 CDT 2014

Total time taken to generate the page: 0.13115 seconds