Query parameter in export was introduced in 8i versions. It appears that you
are using 8.0. (Your command is using 'exp80'). Try 'exp80 help=y' from a
Command Prompt window to see what is available..
HTH
- Kirti
> -----Original Message-----
> From: Ramlal K Chithu [SMTP:TS2182_at_emirates.com]
> Sent: Tuesday, September 19, 2000 7:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Export (Query parameter)
>
> Dear Steve,
>
> I have given like this in command prompt ...
>
> exp80 userid=clp_ownr/clp_ownr_at_clpd file=myfile.dmp rows=y
> tables=system_control query="where code is not null"
>
> That is all.
> It comes up with error like Query parameter is unknown.
>
> Please help me.
>
>
>
> -----Original Message-----
> Sent: 19 September 2000 15:51
> To: Ramlal K Chithu
>
>
> Hi Ramlal,
>
> Check which exp executable your are using as follows.
>
> type exp
>
> It could be that you are using an earlier exp binary.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
> @
> @ Going to OpenWorld?
> @ Catch the Ixora performance tuning seminar too!
> @ See http://www.ixora.com.au/seminars/ for details.
>
>
> -----Original Message-----
> Sent: Tuesday, 19 September 2000 20:01
> To: Multiple recipients of list ORACLE-L
>
>
> hi,
> We are doing export of a table using the parameter "query" from Oracle8i
> database.
> So in the query parameter we have mentioned like id between 100 and 1000.
> When we run , it give an error like unknown parameter "Query".
> do you we have change the settings for this since it is new feature in
> export utility?
>
> Thanks
> Ramlal.
> --
> Author: Ramlal K Chithu
> INET: TS2182_at_emirates.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).
> --
> Author: Ramlal K Chithu
> INET: TS2182_at_emirates.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
Received on Tue Sep 19 2000 - 08:03:40 CDT
