Is exp and imp utility supported in 11g ?
please provide me some oracle documentation link.
Can a dump file of 10g which is created with 'exp' utility be imported in 11g using 'imp' utility.
Or this has to be done only with 'expdp' and 'impdp' utility.
yes you can do , but you have so many features with datapump(compression, faster), then why should you use still taraditional? but still exp/imp are for compatibility. in 11g
Edited by: CKPT on Aug 11, 2010 12:39 PM
There are a number of reasons you may want to use the traditional IMP/EXP.
To use Data Pump you need the DBA to set you up.
The traditional tools are client/server oriented, so as long as you have a user connection to the DB you can do use EXP and IMP.
But, to use DataPump, you have to request access to a Server Dir (that means you need to ask both the DBA and the Sys admin to set you up).
If you are exporting from one server and importing into another, then you may need 4 guys to give you access, disk space, and what not.
Last and least, the backward compatibility. If, for example, you have scripts that use IMP/EXP to automatically move stuff between two DBs, you may not want to start rewriting them.
I really hope they don't de-support the good old traditional nice IMP/EXP.