Re: Undo Tablspace and OMF

Hi Ora,

Get rid of the space between auto and extend (it should be autoextend off).

And obviously get rid of segment space management manual.

Cheers

Richard

Ora wrote:
>
> Oracle 9i: Release 2 / Win2k
>
> I was trying to create an OMF data file Undo Tablespace:
>
> Create Undo Tablespace < tablespacename>
> Datafile size 20m
> Auto extend off
> Segment Space Management Manual;
>
> The statement failed saying ‘Auto extend off ‘ & ‘Segment Space
> Management' are invalid options.
>
> But I was able to successfully use ‘ auto extend off' at the data
> file level
>
>
> Alter Tablespace <undotablespacename> add datafile size 20m auto
> extend off;
>
> Is the option 'auto extend off' invalid in create Undo Tablespace
> statement ?
>
> TIA
> OrA

Received on Wed Aug 14 2002 - 00:31:50 CDT