René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

alter tablespace in oracle

alter tablespace TS add datafile

alter tablespace ts_sth 
  add datafile 'c:\xx\sth_04.dbf' size 4M autoextend off;
Adding a datafile to a database is a structural change that requires a backup.

alter tablespace TS begin backup

This command can be used for a hot backup

alter tablespace TS end backup

This command can be used for a hot backup

alter tablespace flashback on | off

alter tablespace TS force logging

If a tablespace in in force logging mode, redo is generated, even if an operation uses nologging.
The entire database can be put into force logging mode using alter database force logging.