Trying to export data via script but getting "Available memory is almost depleted" error

[Ap_1]

I have created fix script to export almost 1lakh computer data along with few details from sys_audit table.

The script is working fine for 4k data, but after that for more than 5k data fix script is automatically getting canceled with error message "Available memory is almost depleted".

Can anyone please help me on this.

[Ankur Bawiskar]

@Ap_1 

what's your script and are you creating csv file?

why not use mid server export set capability for this?

[Ap_1]

Hi @Ankur Bawiskar,

I am creating CSV file from the script and attached my script.

Thanks,

Aprajita

[Ankur Bawiskar]

@Ap_1 

it's breaking possibly because of large number of records.

why not divide it in chunks of 20k records and then you can merge the csv at your end?

OR

you can use export set capability using mid server

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ap_1]

@Ankur Bawiskar

I am trying to break into less record only, i.e running the query for last 3months data from Computer table, which has 5k data.

That also is not working, I am getting same error.

Thanks,

Aprajita