Chiku, Use the 8.1.7 export utility to export the tables and the 9.2 import utility to import the tables. He is probably using the 9.2 export utility to export - and the utility is looking for the 9.2 version export support tables. Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- From: Chirag DBA [mailto:ChiragDBA@xxxxxxxxx] Sent: Thursday, October 07, 2004 6:13 AM To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx Subject: Export error .. One of my frnd is trying to generate development DB from production. Production machine is 8.1.7 and development DB where he want to upload a DB is 9.2. He is taking export from his machine n getting this error. There is no DB migration is done. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production JServer Release 8.1.7.4.1 - Production EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully Any Idea ????? - Chiku -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l