has anyone experience with WHERE clauses referencing *other* than the table-to-be-imported?
- Ross "WWJD? JWRTFM!" -----Original Message----- Sent: Tuesday, January 08, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Hi All, Export has supported queries since 8i an example from the 817 documentation is: exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' AND SAL \<1600\" hope this helps, John [EMAIL PROTECTED] wrote: >I don't remember export supporting queries. Why don't you create a temp >table or tables, eg. create table t_linemto as select * from linemto where >PROJ_CODE='CF-804', and then export the temp tables? > > > > rpapnoi > @chemtex.co.i To: Multiple recipients of list ORACLE-L > n <[EMAIL PROTECTED]> > Sent by: root cc: > Subject: EXPORT WITH QUERY CLAUSE in win NT > > 01/08/2002 > 01:00 AM > Please > respond to > ORACLE-L > > > > > > >Hi list > >I want to export few tables with a common column in all. My OS is WinNT and >db version is Oracle 8.1.6 > >I am using the folling command > >exp username/password@nts7 tables=(linemto,specs,specmast,password) >file=c:\MTO.DMP QUERY="where PROJ_CODE='CF-804'" > >It gives me the following error: >EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help >EXP-00000: Export terminated unsuccessfully > > >Where I am missing? Can someone correct me. >Regards, >Ramesh D Papnoi >Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India >(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer) >http://www22.Brinkster.com/rpapnoi > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
