Re: Problems whit import.

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
>
>
>
>
Received on Sat Feb 13 1999 - 20:54:22 CST