I think Howards point wasn't that you might never want files greater than
2gb , but that you would not want DATAfiles greater than 2gb in size.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3D1C3BAC.B1E42591_at_mytoys.de...
> "Howard J. Rogers" wrote:
>
> > You mean via import?! Yup, I can see that this is a perfect recovery
> > strategy for "LARGE tables". Not.
>
> Well, there are few situations where one could need files > 2GB. A client
once
> had a system crash and when the database was up again (lot of recovery
problems)
> the only way to save the data was using export (DUL was no option). There
where
> about 60GB of data, version was 8.0.5, so no filesize parameter for
export! We
> had to export every single table and some tables had to be splitted in two
or
> three parts. Files > 2GB would have been nice.
>
> Regards,
>
> Knut
Received on Fri Jun 28 2002 - 05:44:32 CDT
