alter database

ALTER DATABASE db_name ADD LOGFILE MEMBER 'file specification' REUSE TO GROUP n;

ALTER DATABASE db_name ADD LOGFILE MEMBER 'file specification' REUSE TO ('file_specification', 'file_specification') ;

ALTER DATABASE tablespace RENAME FILE 'old name' TO 'new name';

AULT pg. 162

alter tablespace

moving a datfile

ALTER TABLESPACE tablespace OFFLINE;

cp tablespace /another/location

ALTER TABLESPACE tablespace RENAME DATAFILE 'old name' TO 'new name';

ALTER DATABASE tablespace RENAME FILE 'old name' TO 'new name';

ALTER TABLESPACE tablespace ONLINE;

rm tablespace

options for OFFLINE

NORMAL

wait for users to log off

TEMPORARY

IMMEDIATE

FOR RECOVERY