Im sorry if this message is posted twice, but I had some problems with my
newsserver, and I have waited 24 hrs for my previous post to appear, so I'll
take my chances! :D
Im doing an import on AIX from a set of tapes exported on Oracle 7 into my
Oracle 9i. This set of tapes were not made by me, but the parameterfile was
sent to me along with the tapes. Seeing as I couldn't import the first set
of tapes, they made two other sets of tapes, all with different parameters,
but the same thing happens with all of these three sets.
Parameters 1: BUFFER=4096 VOLSIZE=2000M
Parameters 2: BUFFER=8192 VOLSIZE=2048M
Paramteres 3: BUFFER=16384 VOLSIZE=4000M
So, I do a full import with these same parameters. It created the
tablespaces, and starts importing data into the tables it creates. At the
end of tape #1, I am asked to mount the next volume, and it continues
importing data happily for a while. Then, when it's about 75% into the 2nd
tape (and I know this because they sent me their log and noted where they
had changed tape) it stops and asks for the 3rd tape. Well, I changed tape
and it just runs through the tape looking for the data it is expecting,
but - naturally - does not find it.
Anyone have any idea what might be wrong?
Thanks in advance,
H Johnsen