如何在URtracker上建立数据库
发布网友
发布时间:2022-04-20 09:05
我来回答
共1个回答
热心网友
时间:2023-09-07 01:00
> CREATE DATABASE orote1
USER SYS IDENTIFIED BY SYSPWD
USER SYSTEM IDENTIFIED BY SYSTEMPWD
CONTROLFILE REUSE
MAXINSTANCES 1
MAXLOGFILES 5
MAXLOGMENBERS 5
MAXLOGHISTOYR 1
MAXDATAFILES 100
LOGFILE GROUP 1 (‘/app/oracle/testdb/redo01.log’) SIZE 10M,
GROUP 2(‘/app/oracle/testdb/redo01.log’) SIZE 10M,
DATAFILE ‘/ Aapp/oracle/testdb/zhangsan01.dbf’ SIZE 100M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE tbs1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ‘zhangsantemp01.dbf’ SIZE 10M REUSE
CHARACTER SET US7ASCII;