December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER DATABASE
CREATE Syntax:
CREATE DATABASE [dbname] CONTROLFILE [REUSE] LOGFILE [GROUPinteger] (filename[,[GROUPinteger]filename...]) [MAXLOGFILESinteger] [MAXLOGMEMBERSinteger] [MAXLOGHISTORYinteger] [MAXDATAFILESinteger] [MAXINSTANCESinteger] [ARCHIVELOG | NOARCHIVELOG] [CHARACTER SETcharset] [NATIONAL CHARACTER SETcharset] [SET TIME_ZONE = '{{+ | -} hh:mi | time_zone_region}'] [USER SYS IDENTIFIED BY password] [USER SYSTEM IDENTIFIED BY password] [DEFAULT TEMPORARY TABLESPACE tablespace_name [TEMPFILEfilename] [EXTENT MANAGEMENT LOCAL] [UNIFORM [SIZE integer [ K | M ]]]] [UNDO TABLESPACEtablespace_name[DATAFILEfilename[autoextend_clause] DATAFILE (filename[,filename...])[Autoextend_Clause]]] [EXTENT MANAGEMENT LOCAL]
ALTER Syntax:
ALTER DATABASE [dbname] { ARCHIVELOG | NOARCHIVELOG | MOUNT [[STANDBY | CLONE] DATABASE] | CONVERT | OPEN [{READ WRITE [{RESETLOGS | NORESETLOGS}] [MIGRATE] | READ ONLY }] | ACTIVATE [PHYSICAL | LOGICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]] | SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE} | REGISTER [OR REPLACE] {PHYSICAL | LOGICAL } LOGFILElogfile_descriptor[,logfile_descriptor...] | START LOGICAL STANDBY APPLY [NEW PRIMARY dblink | INITIAL scn_value] | {STOP | ABORT} LOGICAL STANDBY APPLY | COMMIT TO SWITCHOVER TO {PHYSICAL | LOGICAL} {PRIMARY | STANDBY} [{WITH | WITHOUT} SESSION SHUTDOWN] [WAIT | NOWAIT] } { RESET COMPATIBILITY | CONVERT | ENABLE [PUBLIC] THREADinteger ...