This content has been marked as final. Show 6 replies
you can use data pump, no problems either if you use exp/imp, but like you told, data pump is faster.
Hi, We need to downgrade our oracle 10G server from an Enterprise Edition to a Standard Edition for licence purpose. I have been reading the tread in this forum and the oracle metalink related (ID 465189.1 , ID 139642.1). I also have been reading other information in the web. I still have 1 question, to export and import can I use the ORACLE DATAPUMP utility, EXPDP, or I need to use the old ORACLE export utility, EXP? Please let me know, the difference for us is huge, since the EXPDP and IMPDP is mutch faster than the old EXP and IMP utility. Thanks. regards Nunzio
thanks for you answer, but like I wrote in the first message, I went trough the document you point me.
The document says that "the standard edition EXP utility is prefered to be used to export the data", so, is "prefered", but there is a reason for that!? Can I use the EXPDP, that is mutch faster!? the EXPDP and IMPDP is available on ORACLE 10G SE!?
Please let me know.
P.S. Thanks "fran" for you answer, I hope that your answer is correct so I should go ahead with the EXPDP!!!
Edited by: Nunzio Cafarelli on Mar 14, 2012 3:32 PM
Edited by: Nunzio Cafarelli on Mar 14, 2012 3:33 PM
One thing I suggest - check the License document for the version of the database.
Go to http://tahiti.oracle.com and get to Chapter 1 of the License doc. If the feature (in this case Data Pump) has different rules based on Edition, it will be listed there.
If not listed, it should be available on all editions, as the doc is about exceptions. But you should verify by talking to Oracle, since it's your license.
(In this case, Data Pump is included in the free Express Edition - http://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm - so it's pretty safe to assume it's in Standard.)