From hamcdc@yahoo.co.uk Fri, 08 Jun 2001 09:32:25 -0700 From: =?iso-8859-1?q?Connor=20McDonald?= Date: Fri, 08 Jun 2001 09:32:25 -0700 Subject: Re: EXPORT PROBLEM on 8.1.7 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Check out metalink, - its most probably mismatch between export versions (and catexp in particular), but there have been bugs in the past as well which caused 904's... hth connor --- Arslan Dar wrote: > > Hi there > > I am doing a USER LEVEL export as a user with > EXP_FULL_DATABASE role > from oracle 8.1.6 HOST > using a remote machine (which have 8.1.7) through > command line (EXP > command). > i am getting following error > > EXP-00008 : Oracle error 904 encountered > ORA-00904 : invalid column name > .... > .... > > EXP-00008 : Oracle error 1003 encountered > ORA-01003 : no statement parsed > ... > > AND at the end of the export > > EXP-00008: ORACLE error 6550 encountered > ORA-06550: line1, column 29 > PLS-00302: component 'IS_TRIGGER_FIRE_ONCE_INTERNAL' > must be declared > ORA-06550: line1, column 8 > PL/SQL : Statement Ignored > EXP-00056: ORACLE error 1403 encountered > ORA-1403 : no data found > EXP-00000: Export terminated unsuccessfully > > I tried it with the user SYS but same error comes, > > The difference is b/w the versions of oracle , one > is 8.1.6 (SOURCE) and > other is 8.1.7 (client) > > > Where do I go from here? > Awaiting your speedy reply. > > Arslan Zaheer Dar > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).