Re: EXP-00056: ORACLE error 1017 encountered

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 12 May 2003 01:49:10 -0700
Message-ID: <a20d28ee.0305120049.1b64158a_at_posting.google.com>


TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<d1dlbv8v088dg2t7350kp2c73dasf27drs_at_4ax.com>...
> froliol_at_yahoo.com (Louis Frolio) wrote:
>
> Have you tried
>
> exp "/as sysba" file=myfile.dmp log=myfile.log full=y rows=n
>
> Only sysdba can do a full export, so you need to 'enable' that role on login...
>

Sorry to say so but this is simply NOT TRUE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Anyone with the exp_full_database role can perform a full export.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon May 12 2003 - 10:49:10 CEST

Original text of this message