RE: Export syntax

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 23 Jul 2002 00:03:25 -0800
Message-ID: <F001.0049F0F7.20020723000325@fatcity.com>

> -----Original Message-----
> From: cosltemp-g.manoj_at_orbitech.co.in
> [mailto:cosltemp-g.manoj_at_orbitech.co.in]
> Sent: lundi, 22. juillet 2002 23:53
> To: Multiple recipients of list ORACLE-L
> Subject: Export syntax
>
>
> 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

What version of Oracle, what OS, which UNIX shell? Are you sure you have the column name right? That syntax was successful in my test:

$ sqlplus quest
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jul 22 23:59:17 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> describe jkilchoer.doctor

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 DOCTOR_ID                                          NUMBER
 DOCTOR_NAME                                        VARCHAR2(30)

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

$ exp quest file=x.dmp tables=jkilchoer.doctor query=\"where doctor_name in \(\'SMITH\'\)\"
Export: Release 8.1.6.0.0 - Production on Mon Jul 22 23:59:33 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified tables via Conventional Path ... Current user changed to JKILCHOER

. . exporting table                         DOCTOR          1 rows exported

Export terminated successfully without warnings.  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

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 - 03:03:25 CDT