ALTER SYSTEM |
Modifie le système |
|---|---|
| Oracle Database SQL |
Syntaxe
| ALTER SYSTEM ARCHIVE LOG archive_log_clause |
| ALTER SYSTEM CHECKPOINT [GLOBAL | LOCAL] |
| ALTER SYSTEM CHECK DATAFILES [GLOBAL | LOCAL] |
| ALTER SYSTEM FLUSH SHARED POOL |
| ALTER SYSTEM {ENABLE | DISABLE} DISTRIBUTED RECOVERY |
| ALTER SYSTEM {ENABLE | DISABLE} RESTRICTED SESSION |
| ALTER SYSTEM RESUME |
| ALTER SYSTEM SUSPEND |
| ALTER SYSTEM SHUTDOWN [IMMEDIATE] dispatcher_name |
| ALTER SYSTEM SWITCH LOGFILE |
| ALTER SYSTEM KILL SESSION 'int1, int2' [POST TRANSACTION] [IMMEDIATE] |
| ALTER SYSTEM DISCONNECT SESSION 'int1, int2' [IMMEDIATE] |
| ALTER SYSTEM SET parameter = value [COMMENT 'text'] [DEFERRED] [SCOPE = {MEMORY|SPFILE|BOTH} [SID = 'sid' [,SID =...]] | DEFERRED] |
| ALTER SYSTEM RESET parameter(s) [SCOPE = {MEMORY|SPFILE|BOTH} [SID = 'sid' [,SID =...]] | DEFERRED] |
| ALTER SYSTEM QUIESCE RESTRICTED |
| ALTER SYSTEM UNQUIESCE |
Description
Cette instruction permet de modifier les propriétés du système de base de données d'Oracle.
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015