Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Problem moving large table to new server 8.1.6
I'm trying to move a table with 300,000 rows from one database to another. Regardless of the approach I use - export/import or using a select/insert script, it hangs after about 1000 rows. I don't get any message at all.
All of my disks have at least 1 GB of free space when this happens.
This is not my area of expertise - I'm trying to do some testing vs. DB2 on linux. I have made the tablespace for the tables much larger than my data, and I've increased the TEMP tablespace and the one I use for indexes (INDX). All of those are shown as ranging from 1% to 14% full.
Is there some other parameter that I need to fix? The table was working on another machine before - I need to move it so that I can use the old machine for something else.
-- Barry Hoggard Chief Technology Officer http://www.investorama.com e: barry_at_investorama.comReceived on Tue Dec 05 2000 - 15:02:54 CST
![]() |
![]() |