oracle-建库语句

创建Oracle数据库的语句：

CREATE DATABASE dbname USER SYS IDENTIFIED BY password USER SYSTEM IDENTIFIED BY password MAXINSTANCES 10 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/u01/oradata/dbname/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/oradata/dbname/sysaux01.dbf' SIZE 325M REUSE UNDO TABLESPACE undotbs1 DATAFILE '/u01/oradata/dbname/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON DEFAULT TABLESPACE users DATAFILE '/u01/oradata/dbname/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/oradata/dbname/temp01.dbf' SIZE 20M REUSE LOGFILE GROUP 1 ('/u01/oradata/dbname/redo01a.log','/u01/oradata/dbname/redo01b.log') SIZE 50M, GROUP 2 ('/u01/oradata/dbname/redo02a.log','/u01/oradata/dbname/redo02b.log') SIZE 50M, GROUP 3 ('/u01/oradata/dbname/redo03a.log','/u01/oradata/dbname/redo03b.log') SIZE 50M;

其中，dbname是要创建的数据库名称，password是数据库管理员的密码。其余参数可以根据需要进行修改。