Export problem.

[rajabalachandra]

hi,

try exporting that problematic table (STREET_NJ) alone.

whether it is the problem with the table or not.

[Puja]

It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

I will try compress method.

Thanks for your help.

[Puja]

exporting that problematic table (STREET_NJ) alone works fine.Problem start when I try a full dadabase export.

Thanks

[jlakhani]

Puja,
try exporting to a compressed pipe(inline compression). I think that will solve your problem. Keep in mind that if you have partitions its much easier to perorm partition exports..

[Thomasps]

Originally posted by Puja
It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

I will try compress method.

Thanks for your help.

I was asking you the size of the export file when the export fails. Refer the links I gave, you will get the scripts to compress or compress and split.