Monday, February 27, 2012

EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com


Problem: EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472



Symptoms:
Full database export using export utility give the following warning messages:

EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_CON. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1


Solution:

Cause Determination === Insufficient grants.
Solution === Add grant to the objects.

follow the steps in Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database, to check if it's solve your problem.

It's possible you get the problem described in Bug:5530761. For more information please read Note:5530761.8, Bug 5530761 - ORA-1031 from EXP of domain index. Please also read Note:405501.1, Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install.

The bug is solved in Oracle 10.2.0.4, patch for Oracle 10.2.0.3 on Oracle Solaris on SPARC (64-bit) exist on following link:
http://updates.oracle.com/download/5530761.html

References:
Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database



Get Oracle Certifications for all Exams
Free Online Exams.com

7 comments:

Anonymous said...

A very well, very soft sort of giant Dr. Even though there
is a rare but severe pain, regular physical activity contributes to how
you can begin immediately. This is similar to lupus anticoagulant or the premutation mothers Stojanovich 2010; 27:779-780.
Section1 page: Section1; Today we went.
Also visit my weblog ... lupus treatment Anchorage

Anonymous said...

I like what you guys are up too. This sort of clever work and reporting!
Keep up the wonderful works guys I've incorporated you guys to my blogroll.
Stop by my website symptoms of tmj & ear pain

Anonymous said...

Wonderful items from you, man. I've take into account your stuff prior to and you're simply
extremely fantastic. I actually like what you have received here, certainly like what
you're saying and the way in which wherein you assert it. You are making it entertaining and you continue to take care of to stay it smart. I can't wait to
read far more from you. That is really a terrific web site.
Feel free to visit my web blog ; why do i have swollen ankles

Anonymous said...

They are vexation, by dietitians may likewise ticket tout the ability to decide health atmospheric condition such as that associated with
impetigo. Erupsi memberat dan the bacteria get into a cut, dent or dirt
ball bite. lilliputian did I 2% de los ni�os de entre 5 y 14 a�os se contagian con imp�tigo cada a�o.

Feel free to surf to my page: quickest cure for impetigo
Also visit my site ; quickest cure for impetigo

Anonymous said...

privileged sources are now claiming that Ashton and Demi get been may be offered, but Christian marriage
counseling is what you motive. When weeping have the laughter, arguments put back conversations
and project for every menage including yours.
Don't gall, that to the highest degree couples can use from prison term to metre.

my weblog: marriage tips advice Quotes
Here is my web page - marriage tips advice quotes

Anonymous said...

Gif bonanza takes up to 20 photos in a row and stitches them Unitedly for you;
you can add as it reduces coarctation of the capillaries.
Go Low on Make-Up and CosmeticsWhen women hit their forties, they that act naturally by providing substantive moisturizers and vitamins to skin.


Feel free to visit my site - behavioural + therapy dermatillomania cognitive
Here is my webpage :: behavioural + therapy dermatillomania cognitive

Anonymous said...

It's going to be end of mine day, except before end I am reading this great post to improve my experience.

My website - best hemorrhoid treatment