Re: Few more Undo Tablespace Queries

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Wed, 14 Aug 2002 17:59:14 +1000
Message-ID: <3D5A0DD2.DDB9F1@oracle.com>

Hi yet again :)

Ora wrote:
>
> Oracle 9i: Rel 2 / Win2k
>
> Can Segment Space Management of an undo Tablespace is only ‘Manual'.
> Can it have Automatic Segment Space Management?

No.
>
> Can data files of one Undo Tablespace be spread across different disks?

Of course if O/S level striping is available.
>
> Can another Undo Tablespace of non-default block size be used ?

No.
>
> Can Data files one Undo Tablespace be a mixture of OMF and non-OMF datafiles?

Yes. There is no real difference (as such) between OMF and Non OMF.

>
> TIA
>
> OrA

Received on Wed Aug 14 2002 - 02:59:14 CDT