Oracle Study Notes: difficult create database

Create Database Test
Controlfile Reuse
Datafile 'd: \ data \ system1.dbf' size 100 m autoextend on next 100 m maxsize Unlimited
Sysaux datafile 'd: \ data \ sysaux1.dbf 'size 100 m reuse autoextend on next 100 m maxsize Unlimited
Default temporary tablespace temp1
Tempfile 'd: \ data \ temp1.dbf' size 100 m reuse autoextend on next 100 m maxsize Unlimited
Undo tablespace undotbs1
Datafile 'd: \ data \ undo1.dbf' size 100 m reuse autoextend on next 100 m maxsize Unlimited
Default tablespace user1
Datafile 'd: \ data \ user1.dbf' size 100 m reuse autoextend on next 100 m maxsize Unlimited
Extent management local autoallocate
Logfile group 1 'd: \ data \ redo1.log 'size 100 m reuse,
Group 2 'd: \ data \ redo2.log 'size 100 m reuse,
Group 3 'd: \ data \ redo3.log 'size 100 m Reuse
Character Set al32utf8
User SYS identified by Oracle
User system identified by Oracle
;

It really took a lot of effort to create an empty database in one day!

First encountered a basic syntax error, and then encountered a ORA-01092, and encountered a ORA-01072 ErrorHow to solve the problem. Not clear!

Key points:

1. Reuse keywords: Reuse should be used as long as it is a physical file or whatever it is. This means to ignore an error that already exists in the file! But it seems that it will re-use some of the existing information of the file, and it will cause the creation to fail, the culprit.

2. As long as it is a tablespace, it can contain N physical files. Unless the Set Default bigfile tablespace database attribute is specified, there can be only one file!

3. datafile corresponds to the system tablespace

4. sysaux datafile corresponds to the sysaux tablespace

5. The logile file group must be specified. There must be at least two groups.

6. Default temporary tablespace

7. Undo tablespace

8. default tablespace Default User tablespace

9. The sga_target must be set to a minimum value before it can be created successfully. This is another executor that causes the creation to fail!

In addition:

The minimum initialization parameter set for manual create database is as follows:

*. Compatible = '10. 2.0.1.0'
*. Control_files = 'd: \ data \ control01.ctl'
*. Db_name = 'test'
*. Sga_target = 200 m
*. Undo_management = 'auto'

Ah!

 

 

 

The minimum statement set for manual create database is as follows:

Create database;

Days!