Now I'm using oracle discoverer 10g and I want to extract may file into excel without splitting into multiple sheets. My files is about greater that 16000 and up and every time it reaches the 16000 rows or more than, it split to another sheet but it spreadsheet has 65000 something rows and I want it into one sheet only. What are the possible reason/cause in splitting in multiple sheets and how can I make it in one sheet only? or does it affect the RAM of the server or the pc that I am using.
hope you can help me on this
...thanks in advance!!!