Index-Organized Tables

An index-organized table (IOT) is a type of table that stores data in a B*Tree index structure.

Creating an Index-Organized Table

  1. Click the New Database Object button on the Standard toolbar.
  2. Select the Table type in the dialog.
  3. Input the table name.
  4. Add columns to the table.
  5. Click Index Organized.
  6. Go to the IOT tab.
  7. Set required index-organized parameters.
  8. Save the document.

To drop an index-organized table, select a required table, and then select Delete on the shortcut menu.

Note

While dropping a table, all its data will be lost.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?