error on export functionality

From: alessandro lagostena <alessandro.lagostena_at_tin.it>
Date: Fri, 07 May 2004 19:23:49 GMT
Message-ID: <9nRmc.216600$rM4.9108304@news4.tin.it>

Hello Gents

I have a problem with a export function,i have a application that every nigth are stopped for backup and after restarted.

When the application is down (but oracle is upper running ) i run an export of the user onwer of all tables.

The enviroment is Oracle 8.7 on solaris 7

The DB have ~ 6 Gb of data (table and index) and i have sufficinet disk space for the entire dump file

The export command is

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y owner=${USERNAME} file=${EXP_FILE} log=${EXP_LOG}

Until some time ago all work fine , now i discored that the script crash with core.

Please note that table column ad row where the proble appear are corrected

I haven't changed nothing on Solaris , Oracle, or table, the only changed is the ammount of data grow

Can someone help me ?

If i disable index i have some benefict ? I need to check some oracle parameter ?

Thanks for the help

Regards LAGO

Follow the tail of some test

Test 1) user export : exp core

 . exporting table            WFEXPRROBOTTEMPLATE       1234 rows exported


. . exporting table               WFEXTERNALMETHOD          0 rows exported

. . exporting table       WFEXTERNALMETHODTEMPLATE          0 rows exported

. . exporting table               WFINTERNALMETHOD      18790 rows exported

. . exporting table       WFINTERNALMETHODTEMPLATE        971 rows exported

. . exporting table                      WFPROCESS

EXP-00065: Error writing lob to the dump file.


. . exporting table             WFPROCESSREQUESTER          0 rows exported

. . exporting table              WFPROCESSTEMPLATE

EXP-00065: Error writing lob to the dump file.


. . exporting table        WFPROCESSTEMPLATEMASTER

EXP-00015: error on row 43 of table WFPROCESSTEMPLATEMASTER, column CLASSNAMEA2A2, datatype 1
EXP-00002: error in writing to export file EXP-00002: error in writing to export fileSegmentation Fault (core dumped)

Test 2) user export : exp core on different tab

. . exporting table WFCONNECTOR 409511 rows exported
. . exporting table WFCONNECTORTEMPLATE 11641 rows exported
. . exporting table WFCREATEPROCESSEVENTAUDIT 0 rows exported
. . exporting table WFDATAEVENTAUDIT 0 rows exported
. . exporting table WFEXCEPTIONEVENTAUDIT 707 rows exported
. . exporting table WFEXPRESSION 15080 rows exported
. . exporting table WFEXPRESSIONROBOT 44729 rows exported
. . exporting table WFEXPRROBOTTEMPLATE 1234 rows exported
. . exporting table WFEXTERNALMETHOD 0 rows exported
. . exporting table WFEXTERNALMETHODTEMPLATE 0 rows exported
. . exporting table WFINTERNALMETHOD 18856 rows exported
. . exporting table WFINTERNALMETHODTEMPLATE 971 rows exported
. . exporting table WFPROCESS
EXP-00015: error on row 20071 of table WFPROCESS, column ROLEPRINCIPALMAP, datatype 113
EXP-00002: error in writing to export file EXP-00002: error in writing to export fileSegmentation Fault (core dumped)

exp

Test3 ) table export of the table where before found the error all work fine

Export: Release 8.1.6.0.0 - Production on Fri May 7 13:27:20 2004

Username: wtadmin
Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > pippo.dmp Received on Fri May 07 2004 - 14:23:49 CDT