Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Full export error (ORA-01031) (Oracle 8.1.7)

ganickJun 4 2002
Hello all,

Please provide any hint/help on the following.

My environment is: Windows 2000 Professional, Oracle 8i rel. 3 (8.1.7) Enterprise Ed.

I use "Administrator" account which is part of ORA_DBA group.
Please note that Security properties of the folder "F:\oracle\oradata\oraavl", where the database files are located, is set for Administrator user, System group, ORA_DBA group to have full control.

I'm trying to do a full export using these commands:
F:\>set ORACLE_SID=oraavl
F:\>set BACKUP_DIR=F:\oracle\backup
F:\>exp 'sys/avlman as sysdba' full=yes file=%BACKUP_DIR%\%ORACLE_SID%.dmp

The error I get is:

. . exporting table VEHICLES 1 rows exported
. . exporting table VEHICLE_CREWS 0 rows exported
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
EXP-00084: Unexpected DbmsJava error -1031 at step 6661
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
EXP-00000: Export terminated unsuccessfully

Thanks in advance.

--Nikos

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2002
Added on Jun 4 2002
1 comment
343 views