Re: Few more Undo Tablespace Queries

Hi Howard,

Congratulations !!

You were the first perosn to have correctly identified the intentional error in my post and as such, a fantastic prize is own it's way.

Such intentional errors are likely to appear again (very likely) so those that missed out, don't worry, another opportunity is just around the corner.

;)

Richard

"Howard J. Rogers" wrote:
>
> "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:23:25 CDT