Home -> Usenet -> comp.databases.oracle -> Import!

Import!

From: H Johnsen <volumehigheNOSPAMr_at_hotmail.com>
Date: Sun, 18 May 2003 15:21:01 +0200
Message-ID: <VMLxa.9794$X2.253_at_news2.bredband.com> 






Hi!



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
Received on Sun May 18 2003 - 15:21:01 CEST












Original text of this message