Lesson 7 | Control file character set |
Objective | New feature of specifying a character set for a control file. |
CREATE CONTROLFILE
syntax has been expanded to optionally accept the database character set name, so that the character set information is available at mount time.CREATECONTROL FILE
statement.
CREATE CONTROLFILE REUSE DATABASE <database name> LOGFILE <log file details along with its group> NORESETLOGS / RESETLOGS DATAFILE <datafile name(s)> MAXLOGFILES <integer value> MAXLOGHISTORY < integer value > MAXDATAFILES < integer value > MAXINSTANCES < integer value > ARCHIVELOG / NOARCHIVELOG CHARACTER SET <character set code>;
CREATE CONTROLFILE REUSE DATABASE orders_2 LOGFILE GROUP 1 ('diskb:log1.log', 'diskc:log1.log') SIZE 50K, GROUP 2 ('diskb:log2.log', 'diskc:log2.log') SIZE 50K NORESETLOGS DATAFILE 'diska:dbone.dat' SIZE 2M MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10 MAXINSTANCES 2 ARCHIVELOG CHARACTER SET F7DEC;