Oracle-L: RE: Export syntax

From: G Sanjay <g_sanjay_at_mks.panasonic.com.sg>
Date: Tue, 23 Jul 2002 01:38:23 -0800
Message-ID: <F001.0049F219.20020723013823@fatcity.com>

Did you run catalog.sql which calls catexp.sql? Sanjay

-----Original Message-----
[mailto:cosltemp-g.manoj_at_orbitech.co.in] Sent: 23 July, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L

Oracle Version: 8.1.7
OS : Sun Solaris
Shell: ksh

the following syntax gives invalid col name :

exp test/test file=expt.dmp tables=x1 query=\"where x1_cd in \(\'207\'\)\"

   EXP-00008: ORACLE error 904 encountered
   ORA-00904: invalid column name
   EXP-00000: Export terminated unsuccessfully

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: G Sanjay
INET: g_sanjay_at_mks.panasonic.com.sg

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_at_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). Received on Tue Jul 23 2002 - 04:38:23 CDT