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

(c) Copyright 1999 Oracle Corporation. All rights reserved.


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

alessandro lagostena wrote:
I just hope that this export is only a part of your backup & recovery strategie,
not all of it.

exp is not a backup tool, but it can help for certain situations.


Regards,
Holger