RE: Export syntax

2002-07-23 Thread G Sanjay 

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

-Original Message-
[mailto:[EMAIL PROTECTED]]
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-8: ORACLE error 904 encountered
   ORA-00904: invalid column name
   EXP-0: Export terminated unsuccessfully
   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: G Sanjay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Export syntax

2002-07-23 Thread cosltemp-g . manoj 


BDY.RTF
Description: RTF file

RE: Export syntax

2002-07-23 Thread Jacques Kilchoer 
Title: RE: Export syntax 





> -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-8: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-0: 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.
 

RE: Export syntax

2002-07-23 Thread Nirmal Kumar Muthu Kumaran 

C:\>EXP SCOTT/TIGER TABLES=EMP QUERY='WHERE JOB IN (''MANAGER'')'

THIS WORKS FINE...

hth.

nIRMAL
(oCP?).

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L


the following syntax gives invalid col name :

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

EXP-8: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-0: Export terminated unsuccessfully
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Export syntax

2002-07-22 Thread cosltemp-g . manoj 


BDY.RTF
Description: RTF file