توضیحات
دستور alter Tablespace برای تغییر ساختار tablespace به کار میرود.
دستور
tablespace در اوراکل با دستور زیر تغییر مییابد:
ALTER TABLESPACE tablespace_name { DEFAULT [ { COMPRESS | NOCOMPRESS } ] storage_clause | MINIMUM EXTENT integer [ K | M | G | T | P | E ] | RESIZE integer [ K | M | G | T | P | E ] | COALESCE | RENAME TO new_tablespace_name | { BEGIN | END } BACKUP | { ADD { DATAFILE | TEMPFILE } [ file_specification [, file_specification ] ] | DROP {DATAFILE | TEMPFILE } { 'filename' | file_number } | RENAME DATAFILE 'filename' [, 'filename' ] TO 'filename' [, 'filename' ] | { DATAFILE | TEMPFILE } { ONLINE | OFFLINE } } | { logging_clause | [ NO ] FORCE LOGGING } | TABLESPACE GROUP { tablespace_group_name | '' } | { ONLINE | OFFLINE [ NORMAL | TEMPORARY | IMMEDIATE ] } | READ { ONLY | WRITE } | { PERMANENT | TEMPORARY } | AUTOEXTEND { OFF | ON [ NEXT integer [ K | M | G | T | P | E ] ] [ MAXSIZE { UNLIMITED | integer [ K | M | G | T | P | E ] } ] } | FLASHBACK { ON | OFF } | RETENTION { GUARANTEE | NOGUARANTEE } } ;