error with export functionalitiy

[Database Administrator]

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

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

"alessandro lagostena" wrote in message news:1jRmc.216571$rM4.9107017@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
--snip--
> Test 2) user export : exp core on different tab
--snip--
> . . 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
--snip--

What is the size of the export dump file when you get the error.
Maye you are hitting the 2G OS file limit.

What happens when you run the export like this:

exp ${USERNAME}/${PASSWORD} buffer=4096 grants=y compress=y
owner=${USERNAME} file=\(file1.dmp,file2.dmp\) filesize=1800MB log=${EXP_LOG}

... BTW: Your buffer value is soo small .. your export must run slow.

Anurag

[Database Administrator]

alessandro lagostena wrote:
> 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
>

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

[Database Administrator]

alessandro lagostena wrote:
> 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
>

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