Re: Smartest way to create test databases (including upgrade) ?

"Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote in message news:<9ulmdu$qd5$1_at_news.gte.com>...
> Actually, it's not the export that needs to be "assigned" an adequate sized
> rb segment. Running a consistent export on an instance that is undergoing
> DML will cause export to go to the rollback segments to get consistent data,
> yes, but the export may require the use of any number of segments depending
> on where the target undo blocks are located.
>
> You want to make sure that any DML during the export remains in the rollback
> segment(s) as long as possible. Do this by having segments large enough to
> span all ( or a gread deal of ) DML transactions that will occur during the
> export.
>
> Hth
>
> -Kevin

Of Course, thanks a lot Kevin.

> > Hmmmmm, but must I not first do a recover ? I mean if I do a startup
> > nomount and create a new controlfile, how does Oracle know how many
> > archive log it have to roll forward ? Remember that it is database
> > files from a hot backup that I use. Not a cold one, but if so, then I
> > suppose your way should work. Or am I wrong here ? (Maybe I should
> > make an export here also, but it is 17 Gb of data, and it would be
> > much better if I could use the hot backup datafiles + redo instead)
> >
> > Thanks for any clarification about this.
> >

Just ignore my question above. I realized that I can first do a startup mount, and then a "alter database rename file 'old_file' to 'new_file', and then do a recover database. Received on Thu Dec 06 2001 - 02:55:51 CST