Re: create database fatal error
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 06 Jul 2008 16:25:11 -0500
Message-ID: <KIack.31536$ZE5.15347@nlpi061.nbdc.sbc.com>
>
> Thanks that worked beautifully. I dont understand the line eniterly
> though, because other examples I have seen dont have the autoextend
> option, so I thought the extent management local was the clue.
>
> In any case thanks for all help
>
> regards
>
> tommy
Date: Sun, 06 Jul 2008 16:25:11 -0500
Message-ID: <KIack.31536$ZE5.15347@nlpi061.nbdc.sbc.com>
Tommy Halsbrekk wrote:
> Michael Austin wrote:
>> >> Were you able to get your problem solved? >> >> Make sure your database directories are owned by oracle user. >> >> Have a look at http://www.fast-track.cc/10g_02.htm >> >> - specifically these lines: >> DATAFILE '/usr/oracle/OraHome1/oradata/aultdb1/test/system01.dbf' SIZE >> 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED >> EXTENT MANAGEMENT LOCAL >> >> AUTOEXTEND ON will automagically add space to the file as needed.
>
> Thanks that worked beautifully. I dont understand the line eniterly
> though, because other examples I have seen dont have the autoextend
> option, so I thought the extent management local was the clue.
>
> In any case thanks for all help
>
> regards
>
> tommy
Now, it would interesting to find out what is the datafile size after everything is created. Received on Sun Jul 06 2008 - 16:25:11 CDT