| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: EXPORT WITH QUERY CLAUSE in win NT
has anyone experience with WHERE clauses referencing *other* than the table-to-be-imported?
"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
tday6_at_csc.com 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-LCLAUSE in win NT
> n <ORACLE-L_at_fatcity.com>
> Sent by: root cc:
> Subject: EXPORT WITH QUERY
> 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_at_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: rpapnoi_at_chemtex.co.in
>
>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).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: orantdba_at_netscape.net 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: MohanR_at_STARS-SMI.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 Jan 08 2002 - 09:50:25 CST
 |
 |