ALTER DATABASE |
Modifie une base de données |
|---|---|
| Oracle Database SQL |
Syntaxe
|
ALTER DATABASE database_name [[MOUNT] [MOUNT STANDBY DATABASE] [MOUNT CLONE DATABASE] [MOUNT PARALLEL] [MOUNT STANDBY DATABASE] [CONVERT] [OPEN [READ ONLY]] [OPEN [READ WRITE] RESETLOGS|NORESETLOGS [MIGRATE]] [ACTIVATE STANDBY DATABASE] [[NATIONAL] CHARACTER SET char_set] ] | [ [ARCHIVELOG] [NOARCHIVELOG] ] | [ [BACKUP CONTROLFILE TO 'filename' [REUSE]] [BACKUP CONTROLFILE TO TRACE [RESETLOGS] [AS 'filename' [REUSE]]] [CREATE STANDBY CONTROLFILE AS 'filename' [REUSE]] [RECOVER recover_clause] [RECOVER MANAGED STANDBY standby_recover_clause] [END BACKUP] ] | [ [CREATE DATAFILE 'filename' AS filespec] [DATAFILE 'filename' ONLINE] [DATAFILE 'filename' OFFLINE [DROP]] [DATAFILE 'filename' RESIZE int K | M] [DATAFILE 'filename' AUTOEXTEND OFF] [DATAFILE 'filename' AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M | UNLIMITED]] [DATAFILE 'filename' END BACKUP] [RENAME FILE 'data_file_name' TO 'data_file_name'] ] | [ [TEMPFILE 'filename' ONLINE] [TEMPFILE 'filename' OFFLINE] [TEMPFILE 'filename' DROP [INCLUDING DATAFILES]] [TEMPFILE 'filename' RESIZE int K | M] [TEMPFILE 'filename' AUTOEXTEND OFF] [TEMPFILE 'filename' AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M | UNLIMITED]] ] | [ [ADD LOGFILE [THREAD int] [GROUP int] filespec] [ADD LOGFILE MEMBER 'filename' [REUSE] TO GROUP int] [ADD LOGFILE MEMBER 'filename' [REUSE] TO 'filename'] [DROP LOGFILE GROUP int] [DROP LOGFILE ('filename')] [DROP LOGFILE MEMBER 'filename'] [RENAME FILE 'redolog_file_name' TO 'redolog_file_name'] [CLEAR [UNARCHIVED] LOGFILE GROUP int [UNRECOVERABLE DATAFILE]] [CLEAR [UNARCHIVED] LOGFILE ('filename') [UNRECOVERABLE DATAFILE]] ] | [ [CREATE STANDBY CONTROLFILE AS 'filename' [REUSE]] [SET DBLOW = 'text'] [SET DBHIGH = 'text'] [SET DBMAC = ON | OFF] [ENABLE [PUBLIC] THREAD int] [DISABLE THREAD int] ] | [ [RENAME GLOBAL_NAME TO database [domain]] [RESET COMPATIBILITY] ] |
Description
Cette instruction permet d'effectuer l'ouverture et/ou la modification d'une base de données.
Exemples
L'exemple suivante ouvre la base de données en mode lecture seulement :
- ALTER DATABASE OPEN READ ONLY;
L'exemple suivante ouvre la base de données en mode lecture/écriture et efface les journaux de bord de refaire en ligne :
- ALTER DATABASE OPEN READ WRITE RESETLOGS;
L'exemple suivante effectue la récupération d'espace table à l'aide de processus de récupération parallèle :
- ALTER DATABASE RECOVER TABLESPACE tbs_03 PARALLEL;
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015