An SQL script can also be used to build a database. The following will be included in the script:
The database’s name
The SYS user’s password
The device user’s password
At least three redo log classes are available online. In my view, each redo log group should have at least two members.
The database’s character set and national character set
SYSTEM and SYSAUX tablespace locations and sizes: These tablespaces will be used to store device information.
As the database’s default tablespace, we will define a normal tablespace.
Then specify a temporary tablespace to use as the database’s default temporary tablespace.
Now we will build an undo tablespace.