Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 28 Jun 2002 12:34:20 +0200
Message-ID: <3D1C3BAC.B1E42591@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:34:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US