RE: Large data movement to new partitioned table

What's wrong with "create table as select..." or "create table ... / insert ... Select ..." ? Fastest, easiest way. Load with the nologging hint and the parallel option if applicable. Add indexes and constraints after the data has been moved.

PL/SQL loop is definitely a bad idea. First off, it will be a lot slower.

-----Message d'origine-----
De : oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] De la part de Knight, Jon

  I have a couple of large tables (average 350,000 recs/day) that I need to
move to a different schema. We have almost 1 year of data. They are currently traditional table structures and I'm moving them to partitioned
tables. The table names are different between schemas.

  We have already created the partitioned tables. I'm wondering if export/import will do the trick. Will the records go into the correct partitions? What about the different table names? I had planned to use pl/sql, but thought I'd ask for other suggestions first. If you don't have
an alternative suggestion, could you please comment on whether there is a
more efficient(quicker) pl/sql approach than what I have below. Particularly, I'm interested in avoiding rollback errors.

  We're still on Oracle 8i, Sun Solaris.

--
http://www.freelists.org/webpage/oracle-l