Re: createing database results in error ora-01501, ora-00200...

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Mon, 29 Apr 2002 18:53:39 +0200
Message-ID: <3ccd7ae5$0$10885$ba624c82@nntp01.dk.telia.net>

"Christian Satzger" <stanley42_at_gmx.net> wrote in message news:2a342cd1.0204290717.6258370_at_posting.google.com...
> Hello,
>
> we are trying to create a database on an Win 2000 Server with Oracle
> 8.1.7, but we only get this error-log:
>
> ----------> snip <-----------------
>
> SQL> startup nomount
> pfile="E:\oracle\admin\SOURCEDB\scripts\init.ora";
> ORACLE instance started.
>
> Total System Global Area 118255568 bytes
> Fixed Size 282576 bytes
> Variable Size 83886080 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 532480 bytes
> SQL> CREATE DATABASE nmeofdb
> 2 MAXINSTANCES 1
> 3 MAXLOGHISTORY 1
> 4 MAXLOGFILES 5
> 5 MAXLOGMEMBERS 5
> 6 MAXDATAFILES 100
> 7 DATAFILE 'E:\oracle\oradata\nmeofdb\system01.dbf' SIZE 325M
REUSE
> AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
> 8 UNDO TABLESPACE "UNDOTBS" DATAFILE
> 'E:\oracle\oradata\nmeofdb\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND
> ON

<SNIP>

You are creating an 8.1.7 db with UNDO tablespace?

Peter Received on Mon Apr 29 2002 - 11:53:39 CDT