| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with import of a ~2Gig table
Also, the import was going from Oracle 7.3.4 into Oracle 8. What
eventually happenned is that it ran out of extents. The size of the
first extent was 1.8 gig (the original size of the table) The sizes of
next were something like 30Megs. I don't understand how Oracle can
create a 6Gig table out of a 2Gig one. Also, when I export
23201267 rows exported
after the import terminated:
SVRMGR> select count(*) from base_free.manager_close;
COUNT(*)
What's going on?
On Mon, 16 Aug 1999 21:27:08 GMT, netcomradeNOSPAM_at_earthlink.net (NetComrade ) wrote:
>Hi,
>
>I am trying to import a table from one DB to another. I set feedback
>to 100000 (INDEXES=n, bigg Buffer, etc, etc)so I can see what's going
>on. Import takes less then an hour (via Direct), export was never
>successful (although right now it is running for the longest I have
>seen--about 7 hours), but the weird part is, when I set feedback to
>the same 100000, I get much more dots then I am supposed to. My table
>has around 27Mil rows, but if I add up all the dots, I will probobly
>get three times that amount.. any suggestions? Serious Bug?
>Workarounds? When I look at unix top, I can see that imp is indeed on
>top...
>
>I am confused. :)
>
Received on Mon Aug 16 1999 - 16:58:45 CDT
 |
 |