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