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-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au] Sent: 19 September 2000 15:51
To: Ramlal K Chithu
Subject: RE: Export (Query parameter)

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-----
From: Ramlal K Chithu [mailto:TS2182_at_emirates.com] Sent: Tuesday, 19 September 2000 20:01
To: Multiple recipients of list ORACLE-L Subject: Export (Query parameter)

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).