Re: Manual CREATE DATABASE for 10g on RedHat Linux ES 3

Setting undo_management=auto in init.ora did the trick.

Morten wrote:
> 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 - 08:03:49 CST