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
Hi;1 person found this helpful
Converting An Enterprise Edition Database To Standard Edition [ID 139642.1]
Helios, just a point, the document which you refer is based on an Oracle 8i database, so no data pump appears.
Differences Between Enterprise, Standard and Personal Editions on Oracle 8.1 [ID 112591.1]
like he is using 10g edition, data pump could be used too.
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.1 person found this helpful
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.)
you answer was useful.
The only mention to the oracle data pump utility is the following:
Feature/Option SE1 SE EE Notes
Parallel Data Pump Export/Import N N Y
so I suppos that I can use the Data Pump without the "parallel" option.
I'll try and let you know.