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

Home -> Community -> Usenet -> c.d.o.server -> Re: saving an entire schema to disk

Re: saving an entire schema to disk

From: Thomas Kellerer <WVIJEVPANEHT_at_spammotel.com>
Date: Wed, 11 Jan 2006 19:11:31 +0100
Message-ID: <42l02jF1jm349U1@individual.net>


gazzag wrote on 11.01.2006 17:12:
> 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.
>

OK, I see you point. But usually the versions of the installed client & server do match, and in that case I do not see any problems.

Regards
Thomas Received on Wed Jan 11 2006 - 12:11:31 CST

Original text of this message

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