top of page
ALTER TABLESPACE name RENAME TO new_name
ALTER TABLESPACE name OWNER TO new_owner
ALTER TABLESPACE name SET ( tablespace_option = value [, ... ] )
ALTER TABLESPACE name RESET ( tablespace_option [, ... ] )
Example
ALTER TABLESPACE index_space RENAME TO fast_raid;
ALTER TABLESPACE index_space OWNER TO mary;
bottom of page