手工创建数据库问题?

显示全部楼层 · 2007-9-26 18:42:10

当我手工创建oracle10g数据库
CREATE DATABASE oradb

MAXINSTANCES 1

MAXLOGHISTORY5000

MAXLOGFILES 254

MAXLOGMEMBERS 5

MAXDATAFILES5000

LOGFILE

group 1('/home/oracle/oradata/oradb/redo01.log') size 100m,

group 2('/home/oracle/oradata/oradb/redo02.log') size 100m,

group 3('/home/oracle/oradata/oradb/redo03.log') size 100m,

DATAFILE '/home/oracle/oradata/oradb/system01.dbf' size 325M

AUTOEXTEND ON MAXSIZE UNLIMITED

SYSAUX DATAFILE 'home/oracle/oradata/oradb/sysaux01.dbf'

size 230M AUTOEXTEND ON MAXSIZE UNLIMITED

UNDO TABLESPACE UNDOTBS1

DATAFILE '/home/oracle/oradata/oradb/undotbs01.dbf' size 100M

AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE temp
tempfile '/home/oracle/oradata/oradb/temp01.dbf' size 40M

CHARACTER SET ZHS16GBK

USER SYS IDENTIFIED BY SYS

USER SYSTEM IDENTIFIED BY SYSTEM;
报警日志报错：
create tablespace SYSAUX datafile'home/oracle10/oradata/oradb/sysaux01.dbf' size 230M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
ORA-1119 signalled during: create tablespace SYSAUX datafile'home/oracle10/oradata/oradb/sysaux01.dbf' size 230M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
帮忙看看怎么回事？谢谢！

千问 · 2007-9-26 18:42:10

ding

千问 · 2007-9-26 18:42:10

不是错误……

千问 · 2007-9-26 18:42:10

???

千问 · 2007-9-26 18:42:10

// *Cause:Usually due to not having enough space on the device.

千问 · 2007-9-26 18:42:10

ding

千问 · 2007-9-26 18:42:10

SYSAUX DATAFILE 'home/oracle/oradata/oradb/sysaux01.dbf'
这不对

千问 · 2007-9-26 18:42:10

ORA-01119 error in creating database file 'string'
Cause: Insufficient space on device.
Action: Decrease the size of the requested file or allocate a file on another device with more available space. If a file size was not specified in the statement, then specify a file size smaller than the available space on the device.