EXPORTED File size exceeds 2 GB; IMPORT PROBLEM...!

[anandharaj]

Hi Gurus,

I am on the process of migration of my database 8.0.5 from win-nt 4.0 to sun solaris 8 . I have exported full data from nt using full=y.

Since the exported file is 2.4 gb size. So I couldn't import the file in Solaris Box. Is it a bug..?

But the same time i have experienced that, if the exported file size is less than 2gb, it is imported without error.

Could some one throw some light on this ...?

Thanks in Advance

Regards

[anandharaj]

The following errors prompted while importing :

IMP-00002: Failed to open exp2110.dmp for read
IMP-00021: Operating system error -error code (dec 79, hex 0x4F)

Regards

[reydp]

I believe you have just reached the maximum allowed size.

I am not familiar with Solaris, but why not try other options of migrating db aside from using EXPORT/IMPORT?

[sazzadur]

solaris has a file limit size of 2gb.

Shaz

[Mr.Hanky]

Can you map a drive to the NT box and point the import.par to use that file? This way you are not pulling the file over, just using it.
MH

[anandharaj]

Let me try...! and come back to you.

[pipo]

you can also use built-in oracle features ... you export using :
exp ... file=a.dmp filesize=2000M

which will give you files with a max size of 2000M ... and there you are

PS : these files are, of course, usable by imp without any problem


[Edited by pipo on 10-22-2001 at 10:02 AM]

[leo]

I am not an expert on Solaris, but it looks like Unix OS setting that does not allow files larger than a caertain size.

Ususally it is controlled by ulimit parameter associated with user's UNIX id. In AIX you can look it up via SMIT utility, not sure about Solaris.

Also in UNIX ( Definately on AIX) there is something called large filesystem which allows to create large ( more than 2G I believe) in a particular filesystem.

Unfortunately I do not have access to Sun now days, but talk to your UNIX Admin or support. It seems to be UNIX setting.

Hope it helps a bit.

Leo

[reydp]

Leo is right there is a large enabled, compressed, and standard file system(journalized) in AIX.

But even if Solaris has this option, I don't think you
can reconfigure a file system once it has data already.
Usually this is done after the creation of the O.S. before
any user data will be put in place.

[leo]

You are right, enabling large file systems can be done only during creation.

leo