|
|
Running
import on files >2GB under Sun Solaris 2.x
Note:
This problem has been identified under both solaris 2.51 & 2.6.
It has not been verified on Solaris 2.7
A
bug in the way the Oracle import utility, imp prevents it from accessing
files that are greater than 2GB on Sun Solaris platforms.
If you try running import
on such a file, the utility will politely complain that it is "Unable to
access file" and exit with an error status.
If you want to import
a file greater than 2GB on Solaris you'll need to do so using this
trick:
1. In the directory of
the export file, create a named pipe using the mkfifo command,
$ mkfifo pipe
2. Cat the contents of
the export file and redirect the output to the pipe, put this process into
the background:
$ cat expdat.dmp > pipe &
3. you'll now have
to run the import taking as the input file the named pipe
$ imp scott/tiger file=pipe buffer=500000 full=y log=import.log fromuser=scott
touser=scott
If the import process
fails due to some other problem, (lack of space, rollback segments, etc)
you'll need to restart step #2.
|
|
|
