Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Problem moving large table to new server 8.1.6

Problem moving large table to new server 8.1.6

From: Barry Hoggard <barry_at_investorama.com>
Date: Tue, 5 Dec 2000 16:02:54 -0500
Message-ID: <90jl6k$3fk$1@news.panix.com>

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.com
Received on Tue Dec 05 2000 - 15:02:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US