Re: saving an entire schema to disk

>> Which version did not allow EXP to be run from the client? I have used EXP on the client side with 8,9 and 10

It's not a question of not being able to *run* exp from the client, it's whether it'll work or not. It depends which way you're going version-wise. As an example from my desktop, with some of the detail obscured:

C:\Temp>exp system/<password>@<instance_name> file=test.exp log=test.log owner=<schema_name>

Export: Release 9.2.0.4.0 - Production on Wed Jan 11 16:07:22 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle8i Release 8.1.7.4.1 - Production JServer Release 8.1.7.4.1 - Production

EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

Seeing as we know nothing about the OP's version(s) your statement was a bit broad-brushed for my liking. Received on Wed Jan 11 2006 - 10:12:21 CST