Oracle exp on VMS

[Gudmundur Josepsson]

Hi,

How can I quote the query clause so that it works on DCL/VMS?

exp userid=scott/tiger@orc1 tables=emp query=where job like 'CLERK'

Thanks,
Gudmundur

[Malcolm Dew-Jones]

Gudmundur Josepsson (gjosepsson@yahoo.com) wrote:
: Hi,

: How can I quote the query clause so that it works on DCL/VMS?

: exp userid=scott/tiger@orc1 tables=emp query=where job like 'CLERK'

Is there some reasn why simply quoting it doesn't work?

exp userid=scott/tiger@orc1 tables=emp query="where job like 'CLERK'"

or, depending on how the interface to exp is implemented, possibly

exp userid=scott/tiger@orc1 tables=emp "query=where job like 'CLERK'"



(My VMS'ing is very out of date though.)