Question: : What parameters are involved
when creating a database? Can create database parameters be
changed?
Answer:
The create database parameters set up the whole database. Follow
the link for some
important create database parameters.
Some immutable create database parameters like the character set
and block size because the whole database must be changed and
recreated.
Other create database parameters can be changed more easily, like
here,
how to change your maxdatafiles create database parameter.
Here is an example of create database parameters at creation
time:
create database
test logfile group 1
('/path/to/redo1.log') size 100M,
group 2
('/path/to/redo2.log') size 100M,
group 3
('/path/to/redo3.log') size 100M
character set WE8ISO8859P1
national character set
utf8
datafile
'/path/to/system.dbf' size 500M autoextend on next 10M maxsize
unlimited extent management local
sysaux datafile '/path/to/sysaux.dbf' size
100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1
datafile '/path/to/undotbs1.dbf' size 100M
default temporary
tablespace temp tempfile '/path/to/temp01.dbf' size 100M;
