Q

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.

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?
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close