Creating Tablespaces

You create tablespaces with the CREATE TABLESPACE command. The following is the generic form of the command with an explanation of the different components:

CREATE TABLESPACE tablespace_name
[DATAFILE clause]
[MINIMUM EXTENT integer [K]]
[BLOCKSIZE integer [K]]
[LOGGING | NOLOGGING]
[DEFAULT storage_clause]
[ONLINE | OFFLINE]
[PERMANENT | TEMPORARY]

  • Tablespace_name is the name of the tablespace that you want to create.

  • MINIMUM EXTENT allows you to ensure that every extent used in the tablespace is at least this size and is always a multiple of this size. You can specify this in either K for kilobytes or M for megabytes.

  • LOGGING, which is the default if not specified, tells Oracle that all tables, indexes, and partitions in ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial