Carmine Marino wrote:
>
> 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
The message says it all...there is an error in the file name or the file
is not readable by you.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Tue Nov 20 2001 - 16:28:12 CST
