top of page

700

CREATE CONTROLFILE

CREATE CONTROLFILE
[ REUSE ] [ SET ] DATABASE database
[ logfile_clause ]
{ RESETLOGS | NORESETLOGS }
[ DATAFILE file_specification
[, file_specification ]... ]
[ MAXLOGFILES integer
| MAXLOGMEMBERS integer
| MAXLOGHISTORY integer
| MAXDATAFILES integer
| MAXINSTANCES integer
| { ARCHIVELOG | NOARCHIVELOG }
| FORCE LOGGING
]...
[ character_set_clause ] ;

logfile_clause::=
LOGFILE
[ GROUP integer ] file_specification
[, [ GROUP integer ] file_specification ]...
character_set_clause::=
CHARACTER SET character_set

bottom of page