Ask the Expert

Enterprise Manager not showing export database option

I've been working on exporting my database. The Enterprise Manager only shows me two options: export tables or export schema. It doesn't show me the export database option. Also, while exporting tables, I am only able to select tables in the SYSTEM schema and nothing else. Can you help me solve this problem? Are there any system/object privileges that I'm missing out on?

    Requires Free Membership to View

In order to export the entire database, you must have been granted the EXP_FULL_DATABASE role. Without this role, you will only be able to export your schema or tables in your schema.

This was first published in May 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: