Re: Few more Undo Tablespace Queries

"Richard Foote" <Richard.Foote_at_oracle.com> wrote in message news:3D5A0DD2.DDB9F1_at_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.

BONG! SQL> alter system set db_cache_size=4m;

System altered.

SQL> alter system set db_2k_cache_size=4m;

System altered.

SQL> create undo tablespace crapundo datafile 'd:\oracle\ora92\db9\crap01.dbf' size 20m blocksize 2k;

Tablespace created.

Non-standard blocksizes are compulsory for SYSTEM and temporary tablespaces only.

Regards
HJR
> >
> > 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 - 04:18:45 CDT