Exporting query data from TOAD to text file

[akonda]

Hi

I am getting below error while exproting query data from TOAD(oracle) to text file:

"out of memory"

And, I am trying to export 1 milion records so I am facing this problem. (I think somewhere I must increase the memory size.)

Please let me know the solution if any anybody faced the same error.


Konda

[keshav0307]

how is this issue related with datastage 7x parallel job?

what is the size of 1 milion records? do you have that much memory.

can you try to spool the output in a file using sqlplus

[chulett]

http://tech.groups.yahoo.com/group/toad/

[sreddy]

Akonda


Are you going to give this data as input some one in your environment?
If that is the reason you have to check with them.

Other wise it is performance issue to your system.

Usually this discussion is not good in DSXchange, but this also part of our work.

Hi

I am getting below error while exproting query data from TOAD(oracle) to text file:

"out of memory"

And, I am trying to export 1 milion records so I am facing this problem. (I think somewhere I must increase the memory size.)

Please let me know the solution if any anybody faced the same error.


Konda

[sreddy]

Akonda


Are you going to give this data as input some one in your environment?
If that is the reason you have to check with them.

Other wise it is performance issue to your system.

Usually this discussion is not good in DSXchange, but this also part of our work.

Thanks to Hulett he has given TOAD group information.

Hi

I am getting below error while exproting query data from TOAD(oracle) to text file:

"out of memory"

And, I am trying to export 1 milion records so I am facing this problem. (I think somewhere I must increase the memory size.)

Please let me know the solution if any anybody faced the same error.


Konda