alter_tablespace::= Description of the illustration alter_tablespace.eps (alter_tablespace_attrs::=) alter_tablespace_attrs::= Description of the illustration alter_tablespace_attrs.eps (default_tablespace_params::=,size_clause::=,datafile_tempfile_clauses::=,tablespace_logging_clauses::=,tablespace...
(table_compression::=—part ofALTERTABLE,storage_clause::=,size_clause::=,datafile_tempfile_clauses::=,tablespace_logging_clauses::=,tablespace_group_clause::=,tablespace_state_clauses::=,autoextend_clause::=,flashback_mode_clause::=,tablespace_retention_clause::=) tablespace_group_clause::=...
ALTER TABLESPACE omf_ts1 ADD DATAFILE; 表領域のロギング属性の変更: 例 次の例では、表領域のデフォルトのロギング属性をNOLOGGINGに変更します。 ALTER TABLESPACE tbs_03 NOLOGGING; 表領域のロギング属性を変更した場合でも、その表領域内の既存のスキーマ・オブジェクトのロギング属性には影響...
alter_tablespace::= Description of the illustration alter_tablespace.eps (alter_tablespace_attrs::=) alter_tablespace_attrs::= Description of the illustration alter_tablespace_attrs.eps (default_tablespace_params::=, size_clause::=, datafile_tempfile_clauses::=, tablespace_logging_clauses::=...
DATAFILE | TEMPFILE ONLINE | OFFLINEUse this clause to take all datafiles or tempfiles in the tablespace offline or put them online. This clause has no effect on the ONLINE/OFFLINE status of the tablespace.The database must be mounted. If tablespace is SYSTEM, or an undo tablespace, or ...
ALTER TABLESPACE omf_ts1 ADD DATAFILE; 表領域のロギング属性の変更例: 次の例は、表領域のデフォルトのロギング属性をNOLOGGINGに変更します。 ALTER TABLESPACE tbs_03 NOLOGGING; 表領域のロギング属性を変更した場合でも、その表領域内の既存のスキーマ・オブジェクトのロギング属性には影響...
tablespace Specify the name of the tablespace to be altered. Restrictions: If tablespace is an undo tablespace, the only other clauses you can specify in this statement are ADD DATAFILE, RENAME DATAFILE, DATAFILE ... ONLINE | OFFLINE, and BEGIN | END BACKUP. For locally managed temporary...
Setting this parameter enables users to use the undo tablespace feature before all application programs and scripts are converted to automatic undo management mode. For example, if you have a tool that uses SET TRANSACTION USE ROLLBACK SEGMENT statement, you can add the statement "ALTER SESSION ...