I'm using BPA v10.7.0.3 and am wondering if there are any size/row limits to datasets. I have a query that is returning 39 columns (short string, date, int fields ... no blob or long text fields) for around 550,000 rows but have another use case that will be querying 6 columns for over 2 million rows and saving the output to a dataset.
I think I recall reading a while back that there was a 2GB limit to the size of datasets but I'm not sure if this is still the case or how someone could go about evaluating the size of a dataset to know 1) If it needs to be split into multiple datasets or 2) If an alternate approach (ie. spool output to flat file, etc) would be more appropriate.
Any help on this one?