Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In Oracle database I have a table with field of type SDO_GEOMETRY. I am using Toad to explore what geometry is contained in that field, but I cant see more than 100 ordinates in spectial Toad window for SDO_GEOMETRY. Also when I am exporting contents of table (save as insert statements) I only get max. 100 ordinates.

How can I see and export all ordinates in SDO_GEOMETRY field?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.