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: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 19 Aug 2004 06:20:41 +0100
Message-ID: <412438a0$0$20251$cc9e4d1f@news-text.dial.pipex.com>


"Dani Speh" <d.speh_at_donau-touristik.at> wrote in message news:5bdedad9.0408180705.fe40f78_at_posting.google.com...
> 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?

I second Dan and Sybrand on the upgrading, but have a couple more comments.

  1. You should, even in 805, be able to export to multiple dump files and specify their size. exp help=y will tell you if the FILESIZE parameter is available, or there is always the utilities manual.
  2. If you are exporting to an indexfile it isn't really a standby is it. It looks more like a way of recreating the objects, and a 2gb indexfile seems a little unlikely. what command are you actually using?
-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Thu Aug 19 2004 - 00:20:41 CDT

Original text of this message

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