Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export (Query parameter)

RE: Export (Query parameter)

From: Ramlal K Chithu <TS2182_at_emirates.com>
Date: Tue, 19 Sep 2000 16:08:34 +0400
Message-Id: <10624.117331@fatcity.com>


Thank you Steve,
It works fine now.
I did the export in server. Becuase client version is 8.0.

-----Original Message-----
From: Ramlal K Chithu [mailto:TS2182_at_emirates.com] Sent: 19 September 2000 16:00
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 - 07:08:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US