OraFAQ Forum: Server Utilities » Getting export error ORA-39212

Home » RDBMS Server » Server Utilities » Getting export error ORA-39212 (10.2.0.1.0 LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting export error ORA-39212 [message #344951]

Tue, 02 September 2008 00:00

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Database version:10.2.0.1.0
Operating system:-Redhat linux

I am getting Oracle error while i am exporting the object in database.This is output of export.

. about to export OE's tables via Conventional Path ...
. . exporting table CATEGORIES_TAB 22 rows exported
. . exporting table PRODUCT_REF_LIST_NESTEDTAB 288 rows exported
. . exporting table SUBCATEGORY_REF_LIST_NESTEDTAB 21 rows exported
. . exporting table CUSTOMERS 319 rows exported
. . exporting table INVENTORIES 1112 rows exported
. . exporting table ORDERS 105 rows exported
. . exporting table ORDER_ITEMS 665 rows exported
. . exporting table PRODUCT_DESCRIPTIONS 8640 rows exported
. . exporting table PRODUCT_INFORMATION 288 rows exported
. . exporting table PROMOTIONS 2 rows exported
EXP-00079: Data in table "PURCHASEORDER" is protected. Conventional path may only be exporting partial table.
. . exporting table PURCHASEORDER
EXP-00056: ORACLE error 39212 encountered
ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9451
ORA-06512: at "SYS.DBMS_METADATA", line 2363
ORA-06512: at "SYS.DBMS_METADATA", line 5865
ORA-06512: at line 1
. . exporting table WAREHOUSES 9 rows exported
. about to export IX's tables via Conventional Path ...
. . exporting table AQ$_ORDERS_QUEUETABLE_G 0 rows exported
. . exporting table AQ$_ORDERS_QUEUETABLE_H 0 rows exported

i don't know whether ORA-06512 error is occur due to ORA-39212 or which is the root cause of the error.Please tell me what i have to do.Thanks.

Report message to a moderator

Re: Getting export error ORA-39212 [message #344952 is a reply to message #344951]

Tue, 02 September 2008 00:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

OK, I give up.
How did you produce this error?
Please use COPY & PASTE.

Report message to a moderator

Re: Getting export error ORA-39212 [message #344960 is a reply to message #344952]

Tue, 02 September 2008 00:37

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

This error is produced by Sheduled export job that is run with system user.This is the part of the script that is doing Export.

$ORACLE_HOME/bin/exp system/ski4now@${ORACLE_SID} full=y file=${EXPDMP_FILE} log=${EXPDMP_LOG} statistics=none consistent=y >> $LOGFILE

Report message to a moderator

Re: Getting export error ORA-39212 [message #344962 is a reply to message #344951]

Tue, 02 September 2008 00:41

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-39212: installation error: XSL stylesheets not loaded correctly
 *Cause:  The XSL stylesheets used by the Data Pump Metadata API
          were not loaded correctly into the Oracle dictionary table
          "sys.metastylesheet." Either the stylesheets were not loaded
          at all, or they were not converted to the database character
          set.
 *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets
          to reload the stylesheets.

Regards
Michel

Report message to a moderator

Re: Getting export error ORA-39212 [message #344970 is a reply to message #344951]

Tue, 02 September 2008 01:04

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Thanks for the prompt reply.

Report message to a moderator

Previous Topic:	Creating dmp file on a button's click
Next Topic:	How to load two data columns into one column in table while loading using sqlloader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 12:55:39 CDT 2024