| exp-00024 on Oracle v7.3 database [message #133370] |
Thu, 18 August 2005 14:14  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
Hi,
We have an archaic oracle database running on AIX on Oracle v7.3.3. I would like to take an export of this database and then import the dump file to a more current version of Oracle. However, when I execute the export command, I'm returned the below errors:
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
From my research, I've found that I would need to run catpatch.sql if I had just upgraded, however I did not upgrade. What do I need to do to make this export successful?
Thanks.
|
|
|
|
| Re: exp-00024 on Oracle v7.3 database [message #133373 is a reply to message #133370] |
Thu, 18 August 2005 15:13  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use the lower version of exp to export the database.
In your case, you exp version 7.3.3 to export from 7.3.3 database
and same 7.3.3 version imp to import into higher database.
It is catexp.sql
Not catpatch.sql.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
