How can one change the number of rows displayed by default in Schema Browser? (4216399)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How can one change the number of rows displayed by default in Schema Browser?
Description

When viewing Tables in the Schema Browser, 500 rows are retrieved in the Data tab, for most Tables, if one wants to see beyond that, scrolling helps.
However, if the Table has a column with a CLOB datatype, only 50 rows are displayed.
Where can one change this to 500?
Resolution

Go to Toad's top menu, View | Toad Options ... | Oracle | General | OCI Array Buffer Size, and set it to "Manual" and increase it as needed.
Additional Information

NOTE: for older Toads, KB 21378 offers "Go to View | Options | Schema Browser | Data and grids | limit grid fetch".

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title