Re: Problems whit import.

Hello Anders,

You are exporting from a NT alpha and importing in a NT Intel. The file that oracle try to create has 2.5Gb. Maybe, This size is too big for NT Intel platform.

Create the BRUGER tablespace at Y2K database, using 2 files with 1.25Gb instead of 1 with 2.5GB. After, run the import. The command CREATE TABLESPACE BRUGER ... will fail with error "tablespace BRUGER already exists" or a like message. But, is not a problem. The import will continue normally.

Your problem can be other, but, I think it is a good try.

Good luck,

Geraldo Milagre Ferreira
Oracle DBA and Instructor
milagre_at_softdes.com.br
www.bestway.com.br/~milagre
+5519.019.254.3692

In article <7a5dsu$emv_at_bgtnsc01.worldnet.att.net>,   "Oracle NetNews" <joey.ogalesco_at_bigfoot.com> wrote:
> Maybe because you've reach the maximum file size in using the Oracle's IMP
> tools.
>
> But let me ask you this. Is you DB and Y2K resides in the same UNIX node ?
> If so, try to create first all the objects from Y2K instance. then use the
> DATABASE LINK. to copy all your objects from DB to Y2K.
>
> Anders Jacobsen wrote in message <7a256o$3vj$1_at_news.dknet.dk>...
> >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
> >
> >
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 14 1999 - 21:37:25 CST