Re: error with export functionalitiy

"alessandro lagostena" <alessandro.lagostena_at_tin.it> wrote in message news:1jRmc.216571$rM4.9107017_at_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 Received on Fri May 07 2004 - 14:33:08 CDT