Re: Problem moving large table to new server 8.1.6

The problem is the size and/or number of your online redo log files. Check your alert log and you will definitely see 'Checkpoint not complete' messages.
You need to enlarge them and/or add more You can only do this by dropping the current ones one for one (alter database drop logfile group <n>)
and adding bigger (alter database add logfile group <n> ('<filename1>','<filename2>') size (at least) 5 M.

Hth,

Sybrand Bakker, Oracle DBA

"Barry Hoggard" <barry_at_investorama.com> wrote in message news:90jl6k$3fk$1_at_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 - 17:03:24 CST