Section courante

A propos

Section administrative du site

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.

Voir également

Article - Les géants de l'informatique - Oracle

Dernière mise à jour : Lundi, le 11 mai 2015