Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Manual CREATE DATABASE for 10g on RedHat Linux ES 3
Hi. The DB assistant failed during installation, so I'll be creating a
database manually. Following the instructions from [1], I managed to
start up sqlplus, have it read my initrem01.ora, and perform a
"startup nomount".
But when I try to create the database as follows:
CREATE DATABASE rem01
CHARACTER SET WE8ISO8859P1
DATAFILE '/opt/oracle-10g/oradata/rem01/datafile_01.dbf' SIZE 200m
SYSAUX DATAFILE '/opt/oracle-10g/oradata/rem01/sysaux_01.dbf' SIZE 50m
DEFAULT TEMPORARY TABLESPACE temp_tbs tempfile
'/opt/oracle-10g/oradata/rem01/temp_01.dbf' SIZE 50m
UNDO TABLESPACE undo_tbs DATAFILE
'/opt/oracle-10g/oradata/rem01/undo_01.dbf' SIZE 50m;
I get:
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode
Uh, what to do?
Br,
Morten
[1]: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/create.htm#i1008760 Received on Fri Nov 19 2004 - 05:16:09 CST
![]() |
![]() |