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

Home -> Community -> Usenet -> c.d.o.server -> help with Import!

help with Import!

From: Glen A Stromquist <stromqgl_at_alpac.ca>
Date: Fri, 27 Jul 2001 18:42:33 GMT
Message-ID: <tCi87.3975$b_3.442902@news0.telusplanet.net>

I did an export of a table that has a large number of chained rows in it for the purpose of re-importing to correct this. My .imp parfile has the same number for buffer= (40000) as the .exp parfile, but I get the ORA-00020 error. Increased by 10k, same error and it stops at the same number of rows each time.

If it exported ok with this should it not import as well?

Should I bump the buffer= way up? the server has 256meg ram.

The column that is giving me grief is a long raw.

thanks in advance Received on Fri Jul 27 2001 - 13:42:33 CDT

Original text of this message

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