Home » RDBMS Server » Server Utilities » Urgent! Can Oracle 8.1.7 export utility be used for 7.3.4 ??
Urgent! Can Oracle 8.1.7 export utility be used for 7.3.4 ?? [message #72139] Thu, 20 March 2003 14:43 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi,
We have been getting the following error while trying to export a table from an oracle 7.3.4 databse using export utility for oracle 8.1.7. Is that even possible?? We tried it using the 7.3.4 export utility and everything works fine. One other question: Is it even possible to import a 7.3.4 databsae directly into 8.1.7? Or should be use a intermediate 8.0.5 database?

Error follows:

exp user1/pass1@mydb file=file.dmp tables=(emp_master)
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
=========================================
EXP-00024 Export views not installed, please notify your DBA
Cause: The necessary Export views were not installed.
Action: Ask the database administrator to install the required Export views.
===================================================
ORA-00942 table or view does not exist
Re: Urgent! Can Oracle 8.1.7 export utility be used for 7.3.4 ?? [message #72140 is a reply to message #72139] Thu, 20 March 2003 17:51 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
always use a lower version of exp/imp tools
to export/import to/from a database of higher version.
Previous Topic: UTL_SMTP package and subject line of email
Next Topic: table locks
Goto Forum:
  


Current Time: Fri Jun 28 15:16:46 CDT 2024