Let's say I have 20 tables in one schema. I aways able to run all kinds of queires successfully against these tables. But a simple getColumns call will got error: "No more spool space in xx" .
getColumns(null, mySchema, myTable, null)
Even for a table contains only 2 columns and couple of rows.
To solve the issue, I have to double the spool space allocated for this user.
Why getColumns call required more spool space and is there guidance for allocating reasonable spool space for a user?