创建数据库oracle

CEATE DATABASE myOraDB

USER SYS IDENTIFILED my SYSPWD
USER SYSTEM IDENTIFILED BY SYSTEMPWD
CONTROFILE REUSE
LOGFILE GROUP 1 ('redo01.log') SIZE 10M
GROUP 2 ('redo02.log') SIZE 10M
MAXLOGFILES 10
MAXLOGMEMBERS 10

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

DATAFILE 'sys01.dbf' SIZE 100M REUSE

EXTENT MANAGEMENT LOCAL

DEFUALT TABLESPACE tbs_1

DEFAULT TEMPOPRARY TABLESPACE temptel

TEMPFILE 'temp01.dbf' SIZE 10M REUSE;

 

mysql下：

1. create database cronie; 

create database cronie;

sql server下两种:

1. 一种是默认的: 
2.  
3. create database cronie; 
4.  
5. 二种是自定议日志文件和数据文件的属性: 
6.  
7. create database cronie  
8. on 
9. ( 
10. name='cronie_data', 
11. filename='c:\aaa\cronie_data.mdf', 
12. size=10mb, 
13. filegrowth=10mb 
14. ) 
15. log on 
16. ( 
17. name='cronie_log', 
18. filename='c:\aaa\cronie_log.ldf', 
19. size=10mb, 
20. filegrowth=10mb 
21. ) 

一种是默认的:

create database cronie;

二种是自定议日志文件和数据文件的属性:

create database cronie 
on
(
name='cronie_data',
filename='c:\aaa\cronie_data.mdf',
size=10mb,
filegrowth=10mb
)
log on
(
name='cronie_log',
filename='c:\aaa\cronie_log.ldf',
size=10mb,
filegrowth=10mb
)

1. 一种是默认的: 
2.  
3. create database cronie; 
4.  
5. 二种是自定议日志文件和数据文件的属性: 
6.  
7. create database cronie 
8. 2>datafile 'cronie.dbs' size 10M  
9. 3>logfile '/u01/oracle/testdb/log1.rdo' size 500K,  
10. 4>logfile '/u02/oracle/testdb/logl2.rdo' size 500K ;