create database with script
CREATE DATABASE TESTCONTROLFILE 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
;
页:
[1]