1. Using Oracle Database Actions for On-Premises Oracle Database
  2. The SQL and Data Modeler Pages
  3. Creating and Editing Database Objects
  4. The Table Properties Dialog
  5. Storage Pane

3.4.1.8 Storage Pane

Enables you to specify storage options for the table.

When you create or edit a table or an index, you can override the default storage options.

  • Organization: Specifies that the table is stored and organized with (Index) or without an index (Heap) or as an external table (External).

  • Tablespace: Name of the tablespace for the table or index.

  • Logging: ON means that the table creation and any subsequent INSERT operations against the table are logged in the redo log file. OFF means that these operations are not logged in the redo log file.

  • Row Archival: YES enables in-database archiving, which allows you to archive rows within the table by marking them as invisible.