Oracle export causes DBMS_EXPORT_EXTENSION error

190 pts.
Tags:
DBMS_EXPORT_EXTENSION
Oracle import/export
I am facing a problem with the EXP command. The execution starts normally, but during the execution about midway, the command gives the error: dbms_export_Extension must be declared. After that, only the structure of the tables goes to backup and no data! This issue never happened in my 3-4 years working with Oracle data. But it is now happening in 5 of my existing clients. Can you help me? Thanks.
ASKED: July 15, 2008  5:04 PM
UPDATED: August 5, 2008  5:19 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

The package dbms_export_extension is needed for doing export files. This function is executed in the SYS context and grants the DBA permission to the user trying to use it. You can revoke the public privilege using following:
REVOKE EXECUTE ON SYS.DBMS_EXPORT_EXTENSION FROM PUBLIC FORCE;.
After revoking the public grant, you should assign the execute role on dbms_export_extension to your export user (e.g. SYS)

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following