On Thu, 7 Oct 2004 15:42:43 +0530, Chirag DBA <chiragdba@xxxxxxxxx> wrote: > 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 ????? Using a different version of the exp utility to the database server version. use th v8 exp to export and the v9 imp to import. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- //www.freelists.org/webpage/oracle-l