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: 2GB Problem with Oracle 8.0.5 an Windows 2000 Server

Re: 2GB Problem with Oracle 8.0.5 an Windows 2000 Server

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 18 Aug 2004 08:18:55 -0700
Message-ID: <1092842384.511278@yasure>


Dani Speh wrote:

> Hi ,
> I have a problem with that database.Every night I make a full export
> from an Production db an an import to an standby db. Everything runs
> fine till yesterday. Import ends with an Error 2237 (Invalid file
> size).I looked at the datafiles and saw the error in the indexfile.
> The indexfile is 2.02 GB and import will not create such a large file.
> I've tried to create the indexfile later( with import INDEXFILE=) but
> import still wants to make a big file.Tonight I'll try the compress
> option.I hope this works. But if not can anybody help me with this
> problem?
>
>
> Dani

  1. Upgrade ... 8.0.5 is paleolithic and unsupported.
  2. Exports are not a backup

While someone may be able to get you past your immediate problem with some kludge ... that is only going to give you the appearance of a solution until something goes terribly wrong.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Aug 18 2004 - 10:18:55 CDT

Original text of this message

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