Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problems whit import.
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