> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> 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.
