| Export Error [message #283878] |
Wed, 28 November 2007 06:01  |
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 #283883 is a reply to message #283878] |
Wed, 28 November 2007 06:12  |
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 #283891 is a reply to message #283878] |
Wed, 28 November 2007 06:27 |
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 #283894 is a reply to message #283878] |
Wed, 28 November 2007 06:35 |
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 #475700 is a reply to message #283963] |
Thu, 16 September 2010 14:29 |
muktha_22
Messages: 527
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 |
 |
Michel Cadot
Messages: 68644
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
