Undo Tablspace and OMF

From: Ora <ora_geek_at_yahoo.com>
Date: 13 Aug 2002 22:32:06 -0700
Message-ID: <fa5d6718.0208132132.77e9663b@posting.google.com>

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:32:06 CDT