I tried using the Sort Stage as well it gives me the same error.
Pl suggest
TIA
Hi ,
The Problem is With Scratch space ,MAy i know abt ur configration settings
SCratch Disk and REsource scratch Disk Space.????
What is the size of Data u are loading to the Target?
I unchecked the PERFORM SORT option. I m using "AUTO" partition option in sort stage.
On the keys I specified to for Sorting if I use the "Sort" option I get Fatal Error: Tsort merger aborting: Scratch space full
but if I use the "Dont sort Previously Sorted" option then about 2000 rows passes thru Sort stage and 1980 is inserted into Oracle Table. In this case the job still says "Aborted".
[/b]
Run your job then simultaneously keep running df -k /tmp to keep monitoring when it runs out. I know unix sort uses this directory by default. I am not sure what tsort uses.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Yes they are. You can do it at the unix level using uniq. But get your code fixed. Its not a woo-haa error that cannot be fixed. Do an exact search on "Tsort merger aborting" for more information.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.