Re: problems creating new database

On 2 Sep 2006 03:37:24 -0700, "MichalF" <faflu_at_gazeta.pl> wrote:

>Andy Hassall wrote:
>>
>> 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.
>
>Thanks a lot! You were right. I thought about it but in the examples on
>oracle's docs there has been nothing about creating tablespace data
>file for default tablespace and CREATE DATABASE statement syntax says
>you can omit 'DATAFILE' clause (as I understand it).
>Looks like you'd better use your common sense than strictly stick to
>docs and examples. Anyway, thanks

 You can omit DATAFILE, but you would need to have enabled OMF using DB_CREATE_FILE_DEST, which you haven't got set.

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