Re: error on export functionality

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
>
> 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
>
>

[...]
>
> 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
>

The first thing to check is whether there is a disk error at the Unix level. Ask you sysadmin or check the /var/adm/messages file (Solaris).   A bad spot or otherwise failing disk could cause this error.

One simple test might be to rename the failed (partial) export file, leaving it in place on disk, then try again, forcing the output to go somewhere else on disk. Or try the export across the network from some other machine.

You have successfully created export files greater than 2 GB in size before, right?

Disabling (or dropping, or using "indexes=no") the index won't make any difference, index data is not stored in an export, only the "create index" statement (using "indexes=y", of course).

--Mark Bole Received on Fri May 07 2004 - 16:07:18 CDT