Re: Problem moving large table to new server 8.1.6

Also, try adding "commit=y" on your IMP command.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:90js50$1eo7b$2_at_ID-62141.news.dfncis.de...
> 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 Thu Dec 14 2000 - 09:37:45 CST