Re: EXPORT ERROR - ASSISTANCE APPRECIATED

Is it possible you're just out of disk space?

do a:

select bytes from user_segments where segment_name = 'your_table';

to find out, roughly.

Regards,

Nigel

In article <36d0cf93.122380533_at_news.localnet.com>,   scottrp_at_localnet.com (Scott) wrote:
> Hi - I am running :
> SCO UNIX System V Release 3.2v4.2
> Oracle7 Server Release 7.1.4.1.0 - Production Release
>
> - I am trying to export an entire table which has about 30,000
> records, the record has a "long raw" field in it (I don't know if that
> matters). Each time I try to export the table I get the following
> error - it does not happen at the same record evertime, it varies from
> about the 8,000th record to the 16,000th record. I have been
> "playing" with the kernel parameters for weeks, and I can't find an
> answer. Any help would be GREATLY appreciated. Thank you for your
> time in advance. Please also email any responses -
> scottrp_at_localnet.com
>
> Thank You
> The error is given below:
>
> . exporting table IMAGES
> EXP-00014: error on row 9944 of table IMAGES
>
> EXP-00222:
> System error message 2
> EXP-00008: ORACLE error 4030 encountered
> ORA-04030: out of process memory when trying to allocate 428 bytes
> (cursor work he,DBA KDBA MAP)
> ORA-07324: smpall: malloc error while allocating pga.
> AT&T System V/386 Error: 12: Not enough space
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 19:58:44 CST