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 -> Problems whit import.

Problems whit import.

From: Anders Jacobsen <aja_at_iak.dk>
Date: Fri, 12 Feb 1999 22:05:48 +0100
Message-ID: <7a256o$3vj$1@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 Received on Fri Feb 12 1999 - 15:05:48 CST

Original text of this message

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