oracle 创建数据库sql语句
时间: 2023-04-09 15:03:03 浏览: 170
可以回答这个问题,Oracle 创建数据库的 SQL 语句如下:
CREATE DATABASE database_name
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
LOGFILE GROUP 1 ('/u01/oracle/oradata/dbname/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oracle/oradata/dbname/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oracle/oradata/dbname/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET utf8
NATIONAL CHARACTER SET utf8
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/oracle/oradata/dbname/system01.dbf' SIZE 1G REUSE
SYSAUX DATAFILE '/u01/oracle/oradata/dbname/sysaux01.dbf' SIZE 500M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/oracle/oradata/dbname/users01.dbf'
SIZE 500M REUSE
TEMPORARY TABLESPACE temp
TEMPFILE '/u01/oracle/oradata/dbname/temp01.dbf'
SIZE 100M REUSE;