Re: Problems whit import.

From: Tanasescu Iosif <iosif.tanasescu_at_bellsygma.com>
Date: Fri, 12 Feb 1999 17:31:58 -0500
Message-ID: <36C4ABDD.4C42C629@bellsygma.com>

Hi Anders,

Your datafile has reached nearly 2.6 GB. There was no problem from the database to handle this size of datafiles, since the datafile has grown steadly. Yes, you was able to use your procedure before, w/o any problem because the size of your datafile was less or equal nealy 2 GB. What is hapening now, is that there is a bug inthe import / oracle DB, that I've already encountered, because of thsi size greather than 2 GB.

Solution for you:

Create the empty instance, and than create only the tablespaces, where you want.

If you want to not have more troubles in the future, split the large tablespaces into several files, with maximum size 2GB.

Run after that your import, with ignore=y, and will work.

Anders Jacobsen wrote:

> I have alot of problems importing our DB to our Y2K oracle instance. Evry
> time i try to do an import i get this error at the start of the import.
>
> Export file created by EXPORT:V07.03.03 via conventional path
> IMP-00017: following statement failed with ORACLE error 2237:
> "CREATE TABLESPACE "BRUGER" DATAFILE 'D:\ORANT\DATABASE\IAK\BRUGER1.DBF'
> SI"
> "ZE 2621440000 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENTS 1
> "
> "MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
> IMP-00003: ORACLE error 2237 encountered
> ORA-02237: invalid file size
> . importing TEST30's objects into TEST30
>
> My new instance is calles Y2K, and the old on i IAK, i have used this method
> before whitout problems, but now i have tryed to make new exports, new
> instances, etc. nothing helps. I use imp73 whit grants=y and ignore=y, but
> it don't works. The import goes on and finish, and i can logon sqlplus, but
> our forms45 application, returns oracle error 4068. The export is from a
> 7.3.3.4 NT alpha, and the DB importing to i 7.3.4 NT Intel.
>
> Any ideas?
>
> Anders

--
Iosif Tanasescu
Conseiller Princ.
Le Group CGI Inc.
1800 McGill College, Suite 1600
Montreal, Quebec, Canada H3A 3J6

Tel:   (514) 281-0149
Pager: (514) 580-1708
Fax:   (514) 847-0071

IIS:itanases
E_mail:Iosif.Tanasescu_at_BellSygma.com Received on Fri Feb 12 1999 - 16:31:58 CST