Re: Export and roles in 8.0.5

On 17 May 2002 13:05:31 GMT, "Mike DiChiappari" <mike_at_mysticsoft.com> wrote:

>I am trying to use the Export utility to export a database that I own. I am
>hoping to do this with the Data Manager tool (on Windows NT). When I run
>Export and login, I do not have access to my database (I can't see it in the
>tool and therefore can not export it).
>
>According to the docs, "To use Export, you must have the CREATE SESSION
>privilege on an Oracle data-base". I ran the Security manager and sure
>enough I have been granted this privilege. How come I can not export my
>database?
>
>Thanks,
>Mike
>
>
Probably as the Datamanager can be used for all kinds of exports (FULL, USER, TABLE) it expects you to have EXP_FULL_DATABASE privilege.
If this is true, you should be capable to do an USER export using the command line exp tool without problem. The commandline exp is also several times faster because no graphical interface is associated.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 17 2002 - 19:02:48 CEST