Database import problem on solaris 2.8 errno 79 overflow...

From: Carmine Marino <cmarino1_at_cox.rr.com>
Date: Tue, 20 Nov 2001 21:25:34 GMT
Message-ID: <iTzK7.21418$QN6.9352403@typhoon.southeast.rr.com>

Hi All,
Any help is greatly appreciated.
I am trying to import a very large dmp file (3.2 GB) into Oracle 8.1.5 on solaris 2.8.
I have plenty of space on the database file partition and my ulimit is unlimited.

I run the following command:

$ imp ausername/apassword parfile=imp.par

the par file:
FILE=/oracle/db_dump/file.dmp
FULL=N
IGNORE=Y
INDEXES=N
CONSTRAINTS=N
GRANTS=N
COMMIT=N
FEEDBACK=1000
FROMUSER=ausername
TOUSER=ausername
LOG=/oracle/db_dump/imp.log

the log file:

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

IMP-00002: failed to open /oracle/db_dump/file.dmp for read IMP-00021: operating system error - error code (dec 79, hex 0x4F) Import terminated successfully with warnings.

ulimit -a:

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
vmemory(kbytes)      unlimited

Thanks in advance!
Carmine
carmine.marino_at_bowlinesolutions.com Received on Tue Nov 20 2001 - 15:25:34 CST