Toad World® Forums

RE: Schema Backup Q


#1

RE: Schema Backup Q


#2

Yes, specify where your copy of EXP.EXE is on your machine. Go to View > Options

Executables Find the entry for Export Click on the flashlight button. If you
have the full Oracle client installed on your machine (not the Instant Client),
you should be good to go! Before Bert speaks up, EXP has been deprecated in
newer versions of Oracle and you’ll want to check out DataPump, but it
writes to the DB server, not the client. It is much faster however and will give
you actual compression (if you’re willing to pay for it). Jeff From:
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of
RobSilver@Halifax.co.uk Sent: Friday, April 09, 2010 8:46 AM To:
toad@yahoogroups.com Subject: RE: [toad] RE: Schema Backup Q Hi Seem to get an
error message “The Oracle Export Utility Executable must be specified” Any idea
how to fix this? Rob Silver Marketing Analyst HSDL Trinity Road Halifax HX1 2RG


#3

Yes – export is dead, long live the new king – data pump J From:
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith Sent:
April 09, 2010 08:02 To: toad@yahoogroups.com Subject: RE: [toad] RE: Schema
Backup Q Yes, specify where your copy of EXP.EXE is on your machine. Go to View

Options > Executables Find the entry for Export Click on the flashlight
button. If you have the full Oracle client installed on your machine (not the
Instant Client), you should be good to go! Before Bert speaks up, EXP has been
deprecated in newer versions of Oracle and you’ll want to check out
DataPump, but it writes to the DB server, not the client. It is much faster
however and will give you actual compression (if you’re willing to pay for
it). Jeff


#4

And just a word of warning… If your Oracle Client is newer than your Server,
then you may have problems even running the expdp and/or impdp. Don’t
upgrade your client too fast! “For it is by sad experience that we have
learned [this]” David utahtoad at gmail dot com Bert Scalzo wrote: Yes
– export is dead, long live the new king – data pump J From:
toad@yahoogroups. com [ mailto:toad@ yahoogroups. com] On Behalf Of Jeff
Smith Sent: April 09, 2010 08:02 To: toad@yahoogroups. com Subject: RE:
[toad] RE: Schema Backup Q Yes, specify where your copy of EXP.EXE is on
your machine. Go to View > Options > Executables Find the entry for Export
Click on the flashlight button. If you have the full Oracle client installed
on your machine (not the Instant Client), you should be good to go! Before
Bert speaks up, EXP has been deprecated in newer versions of Oracle and
you’ll want to check out DataPump, but it writes to the DB server, not
the client. It is much faster however and will give you actual compression
(if you’re willing to pay for it). Jeff