Re: problems creating new database

On 1 Sep 2006 16:13:56 -0700, "MichalF" <faflu_at_gazeta.pl> wrote:

>I have the following problem creating oracle database (10.1.0.3.0):
>
>Create database statement:
>CREATE DATABASE visma

[...]
> DATAFILE '/oracle/OraHome/oradata/visma/system01.dbf' SIZE 300M
>REUSE
> EXTENT MANAGEMENT LOCAL
> SYSAUX DATAFILE '/oracle/OraHome/oradata/visma/sysaux01.dbf' SIZE
>140M REUSE
> default tablespace tbs_1

 You specify a default tablespace...

> DEFAULT TEMPORARY TABLESPACE tempts1
> TEMPFILE '/oracle/OraHome/oradata/visma/temp01.dbf'
> SIZE 400M REUSE
> UNDO TABLESPACE undotbs
> DATAFILE '/oracle/OraHome/oradata/visma/undotbs01.dbf'
> SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
 ... but there's no sign of it being created anywhere in here.

>As a result of running I get disconnected and the following trace:
>/oracle/admin/visma/udump/visma_ora_3310.trc

>ORA-00604: error occurred at recursive SQL level 1
>ORA-02236: invalid file name
>Offending statement at line 6083
>CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
>ORA-01501: CREATE DATABASE failed

 It seems to be trying to make up for the fact that you haven't created the tablespace that you specified as default tablespace, ends up with a blank DATAFILE clause, and falls over.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool