Home » RDBMS Server » Server Utilities » Getting export error ORA-39212 (10.2.0.1.0 LINUX)
Getting export error ORA-39212 [message #344951] Tue, 02 September 2008 00:00 Go to next message
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.
Re: Getting export error ORA-39212 [message #344952 is a reply to message #344951] Tue, 02 September 2008 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Getting export error ORA-39212 [message #344960 is a reply to message #344952] Tue, 02 September 2008 00:37 Go to previous messageGo to next message
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


Re: Getting export error ORA-39212 [message #344962 is a reply to message #344951] Tue, 02 September 2008 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
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
Re: Getting export error ORA-39212 [message #344970 is a reply to message #344951] Tue, 02 September 2008 01:04 Go to previous message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
Thanks for the prompt reply.
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:
  


Current Time: Fri Dec 09 23:40:26 CST 2016

Total time taken to generate the page: 0.12519 seconds