# new 10.5 datapump export perplexing me

**URL:** <https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 3, 2010, 12:52pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469 "2010-05-03T12:52:12Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 3, 2010, 12:52pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/1 "2010-05-03T12:52:12Z")

</div>

new 10.5 datapump export perplexing me

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 3, 2010, 12:52pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/2 "2010-05-03T12:52:13Z")

</div>

Hi folks,

Not sure about the new datapump export tool.

Regardless of the new interface, whenever I click the green arrow to go, I  
receive back a toad message:

Your license does not permit executing “Data Pump Export.”

Am I missing some small detail about the new tool?

Thanks,

Paul

* * *

This email was scanned by MessageLabs

* * *

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [May 3, 2010, 12:54pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/3 "2010-05-03T12:54:47Z")

</div>

Think data pump requires toad dba option

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [May 3, 2010, 12:57pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/4 "2010-05-03T12:57:16Z")

</div>

Or Professional edition, but that screen shouldn’t even be available even  
if the license isn’t correct…

If you do Help \> About, do you see the words ‘Professional’,  
‘Xpert’ or ‘DB Admin module’?

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [May 3, 2010, 12:58pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/5 "2010-05-03T12:58:29Z")

</div>

Data Pump is an Oracle Product. Toad’s Data Pump wizard just makes it  
easier to use. Is it possible that Data Pump is an extra charge product from  
Oracle? That might make sense with the message. The other possibility is that  
when install toad it throws up a screen that asks if you have the license for  
certain Oracle products. Is it possible that Data Pump was on that list and you  
did not tick it off. NOTE toad does not check your license so if you says yes  
that you are licensed and you use the product without a license then you boss  
might get arrested.

---

<div class="post-metadata">

**Author:** ![eklinger](https://avatars.discourse-cdn.com/v4/letter/e/bbe5ce/32.png) [@eklinger](https://forums.toadworld.com/u/eklinger)\
**Post date:** [May 3, 2010, 1:14pm UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/6 "2010-05-03T13:14:46Z")

</div>

Data Pump is included in all versions of Oracle (standard, enterprise). Only  
certain features like advance compression need additional licensing.

The issue is you need Toad DB Admin module to use the wizard.

I guess the message should be a little more specific and probably say

Your Toad license does not permit executing “Data Pump Export.” You  
need the DB Admin Module License to execute this.

Ed

[TeamT]

---

<div class="post-metadata">

**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\
**Post date:** [May 4, 2010, 6:01am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/7 "2010-05-04T06:01:52Z")

</div>

Wonder why the use of the datapump tool has been revoked from 10.1 to 10.5? I have Xpert edition with sql optimizer add-on, and get the same problem on 10.5.

I use this quite a lot and this will probably a good enough reason for me to stick with 10.1.

What a pity…

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 4, 2010, 7:48am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/8 "2010-05-04T07:48:41Z")

</div>

I suggest you contact customer support. They can deal with licensing issues  
better then we can. If you’re paying for Xpert edition, you should have  
this functionality

---

<div class="post-metadata">

**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\
**Post date:** [May 5, 2010, 10:58am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/9 "2010-05-05T10:58:27Z")

</div>

Quest support have said that the datapump export should only be available with the dba add-on.

The reason it was available in 10.1 is apparently a ‘glitch’!

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 5, 2010, 10:58am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/10 "2010-05-05T10:58:27Z")

</div>

Ugh. They are wrong. Data Pump should be available for any version other than  
“Standard”. Is it possible for you to send me your key off-line?  
I’m a Quest employee. I’ll also try to look up your case

---

<div class="post-metadata">

**Author:** ![Crtan77](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@Crtan77](https://forums.toadworld.com/u/Crtan77)\
**Post date:** [May 5, 2010, 11:08am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/11 "2010-05-05T11:08:07Z")

</div>

Hi geigerweb,

Can you send me the case id for the case you mentioned below? I can have someone  
contact you to discuss this further.

Christian Tan

[Christian.Tan@quest.com](mailto:Christian.Tan@quest.com)

---

<div class="post-metadata">

**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\
**Post date:** [May 17, 2010, 7:30am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/12 "2010-05-17T07:30:20Z")

</div>

I guess Quest Support were wrong in their diagnosis, as this is fixed in the 10.5.1 patch that is now available. Datapump export/import works fine without the dba admin module.

---

<div class="post-metadata">

**Author:** ![Mark\_Lerch](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_lerch/32/33_2.png) [@Mark\_Lerch](https://forums.toadworld.com/u/Mark_Lerch)\
**Post date:** [May 17, 2010, 8:00am UTC](https://forums.toadworld.com/t/new-10-5-datapump-export-perplexing-me/9469/13 "2010-05-17T08:00:41Z")

</div>

yes, the license error on Data Pump was the principal reason for the patch
