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: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 20 Aug 2004 08:47:16 +0200
Message-ID: <cg46pm$mu$1@news.BelWue.DE>


Dani Speh wrote:
[...]

>
>
> Hi ,
> 1. The dump file is only about 600MB big. Thats not the problem. The
> problem is that the import would like create an >2GB indexfile (CREATE
> TABLESPACE "DBFINDEX" DATAFILE 'D:\ORACLE\ORADATA\INDXTRS.ORA' SIZE
> 2074M AUTOEXTEND ON NEXT 31457280 MAXSIZE 16777208K DEFAULT STORAGE
> (INITIAL 20480 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 50) ONLINE
> PERMANENT;) -> In the Dump the SIZE Parameter is in BYTES. I create
> now this indexfile prior to the import.
>
> 2. It's not a really standby database. It's only a 'clone' from the
> production db.The vendor of the software wouldn't like that we do
> tests with our own software at the production db and we either.I've
> thougt to export to an indexfile(imp parameter indexfile) before I
> figured out the method with creation of tablespace before import.My
> import parameters are full,commit,ignore,feedback and buffers
>
> Dani

Dani,

please be carefull with your choice of terms. In the context of exp/imp, indexfile is a text file which can be created instead of an import that contains all create index... statements (plus the create table statements commented out) that would be executed upon import. Check imp help=y to know what I mean.

You however, had a problem creating a tablespace that contained an datafile larger 2GB during import. Incidentally, this tablespace seems to be intended to contain indexes. But this doesn't make it an indexfile.

If you had cared to copy the error into your post, instead of using misleading terms, the value of the replies you got would have been quite higher.

So in the future if you post here, always include the exact error message plus the command that you gave, and your mileage will greatly improve.

Still glad you sorted it out yourself.

Cheers
Holger Received on Fri Aug 20 2004 - 01:47:16 CDT

Original text of this message

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