Re: Options to move a large table
- From: Andreas Piesk <a.piesk@xxxxxxx>
- To: Thomas.LaPorte@xxxxxxxxxxxxxx
- Date: Tue, 14 Sep 2010 22:45:55 +0200
Thomas A. La Porte schrieb:
>
> 1) Using CTAS, created a copy of the table took more than 24
> hours.
why is it so slow? because of BLOB? did you ran CTAS/move in parallel?
nologging? tablespace
pre-allocated?
some time ago i moved and compressed a similar sized table (without BLOB
columns) and it was done in
less than 60min. parallel 8, nologging, tablespace was pre-allocated.
regards,
-ap
--
//www.freelists.org/webpage/oracle-l
Other related posts:
