create database with script

最新推荐文章于 2024-07-14 18:16:19 发布

最新推荐文章于 2024-07-14 18:16:19 发布 · 120 阅读

文章标签：

#C #C++ #C#

oracle 专栏收录该内容

25 篇文章

订阅专栏

本文介绍了一个具体的Oracle数据库实例创建过程，详细配置了控制文件重用、日志文件组、数据文件及其自动扩展设置、临时表空间及撤销表空间等关键参数。

CREATE DATABASE TEST
CONTROLFILE REUSE

LOGFILE
GROUP 1 'C:\ORADATA\TEST\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORADATA\TEST\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\ORADATA\TEST\REDO03.LOG' SIZE 10M

DATAFILE 'C:\ORADATA\TEST\SYSTEM01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE 'C:\ORADATA\TEST\SYSAUX01.DBF' SIZE 250M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'C:\ORADATA\TEST\TEMP01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8000M

UNDO TABLESPACE undo
DATAFILE 'C:\ORADATA\TEST\undo01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

CHARACTER SET WE8MSWIN1252

NATIONAL CHARACTER SET AL16UTF16

USER SYS IDENTIFIED BY SOUPERSEEKRET
USER SYSTEM IDENTIFIED BY MYSEEKRET
;