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 -> Re: import using imp 10.2.0.2 commits every row

Re: import using imp 10.2.0.2 commits every row

From: jasper <pharaoh_at_nospammail.net>
Date: 22 Jun 2006 11:59:57 -0700
Message-ID: <1151002797.728438.141670@g10g2000cwb.googlegroups.com>

joel garry wrote:
>
> Mayhaps:
> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2398
>
> "For tables containing LOBs, LONG, BFILE, REF, ROWID, or UROWID
> columns, array inserts are not done. If COMMIT=y, Import commits these
> tables after each row."
>

you're right. the table contains TIMESTAMPs, but unfortunately someone at Oracle forgot to update the list with the affected datatypes in the 'commit' section.

thanks & regards,
-ap Received on Thu Jun 22 2006 - 13:59:57 CDT

Original text of this message

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