Re: Export (Query parameter)

Your userid parameter is userid/password. The database is set by the ORACLE_SID. I think that is your problem.

HTH,
Ruth
----- Original Message -----
From: "Ramlal K Chithu" <TS2182_at_emirates.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 8:00 AM 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:47:10 CDT