Technology

today:
418
yesterday:
783
Total:
1,580,966

Technology

alter tablespace in oracle

admin 2021.08.18 20:18 Views : 48

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.
I want to
List
Write Tag