export with errors

[mike2000]

I have this user with connect and export full database privilege, when I tried to do a full export using this user, I got the below errors. I have about 10 other instances and none of them has this issue except this one.

any advises???



EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_PLAN_EXPORT", line 216
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RMGR_PLAN_EXPORT.grant_sysprivs_exp
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases

[SANJAY_G]

Try 'GRANT EXP_FULL_DATABASE' to the user.

Sanjay

[mike2000]

I did have that privilege on this user

[jovery]

Try Re-running $ORACLE_HOME\rdbms\admin\catrm.sql

If you've run the catexp.sql script after catproc.sql the role definition for EXP_FULL_DATABASE is changed.

HAd this problem before

Regards

[prakashs43]

if u want a full export dump better take it from system or sys user . by doing so u dont need to create a user in the fresh database where u want to import if different from the original one .

[mike2000]

Jovery,

I thought you can run catexp.sql a number of times without having any problem. I know catexp.sql is in catalog.sql so I was wondering that running catexp.sql will modify the role of definition of EXP_FULL_DATABASE????

Can someone please give me some explanation???


what if you do an import or export of any databases that was on different version and we have to run catexp.sql if we want to export the older version. I like to undertand more about the problem

[nagarjuna]

Open catexp.sql and see it's contents...