export with errors
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
Try 'GRANT EXP_FULL_DATABASE' to the user.
I did have that privilege on this user
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
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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 .
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
Last edited by mike2000; 11-05-2002 at 04:03 PM.
Click Here to Expand Forum to Full Width