ALTER TABLESPACE

ALTER TABLESPACE tablespacename [ LOGGING | NOLOGGING] [ RESIZE nnn [K|M|G|T|P|E] ]

The optional but mutually exclusive clauses, LOGGING and NOLOGGING, change the LOGGING state of the specified tablespace. The optional RESIZE clause can be used to change the size of a tablespace in kilobytes (K), megabytes (M), gigabytes (G), terabytes (T), petabytes (P), or exabytes (E). At least one clause is required.

This statement is only available for Oracle database tablespaces and has no effect on other databases. For more detailed information on their effects see the relevant Oracle database documentation.