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